DatamCube

Never failing way to get correct last filled row number in a sheet using VBA

Sheet1.Cells(Sheet1.Rows.Count, 1).End(xlUp).row

Sheet1 is the name of sheet.
1 is the column number which will be like primary column or the main column. It must have data till last filled row even if others column are blank because this will be used as reference to get last row.

Happy Diwali/Happy Learning
Regards DataCube

VBA COLLECTION

The VBA Collection is a simple native data structure available in VBA to store (collect as you wish) objects. VBA Collections are more flexible than VBA Arrays as they are not limited in their size at any point in time and don’t require manual re-sizing. Collections are also useful when you don’t want to leverage there more complex (but quite similar) Data Structures like the VBA ArrayList or even a VBA Dictionary.

Tasks for you Rockers

1.Write vba code using array and split function to move some sheets to new workbook and save this workbook in user folder whose login used while login system.
2. Do the above task but instead of moving just copy sheets.

3. Check if a workbook is read-only mode and ristrict user to click any button with popup.

Let us know incase of any help neded.

I would love to do so.

Life without a Goal is like a race without a finish line

Based on situation how to exit FOR Loop

Excel VBA - exit for loop I would like to exit my for loop when a condition inside is met. How could I exit my for loop when the if condition has been met? I think some kind of exit at the end of my if statement, but don't ...