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

Which one is better xlookup or vlookup?

Give yourself time to just breathe!
•
The journey is long, there are many challenges and tough days along the way, many long nights and many days when you will question yourself and your journey!
•
All things will unfold in time, but right now you might need to just calm down, take a break, reflect in nature or meditate and allow your soul to rest.
•
Just breathe, trust the process and allow the universe time to do it's thing.
•
You will make it to your destination but don't miss the beautiful moments, the moving experiences and the moments that touch your soul.
•
Just Breathe.!!

An ounce of action is worth a ton of theory. - Ralph Waldo Emerson

Winners never quit.
Quitters never win.

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.

The greatest crime in the world is not developing your potential. When you do what you do best, you are helping not only yourself, but the world."

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.

How to use the SPLIT Function (VBA)

MS Excel: How to use the SPLIT Function (VBA) This Excel tutorial explains how to use the Excel SPLIT function with syntax and examples. The Microsoft Excel SPLIT function will split a string into substrings based on a delimiter. The result is returned as an array of substrings.

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 ...

Open Excel file using WILDCARD-

Sub OpenFile()
Dim FilePath As String
Dim FileName_StartWith As String, FileName_EndWith As String

FilePath = "X:\Ram Anuragi\Project\HP Project\09 Oct'17\"

FileName_StartWith = Dir(FilePath & "Dashboard*")
FileName_EndWith = Dir(FilePath & "*Oct2017.xlsx")

Workbooks.Open FilePath & FileName_StartWith
Workbooks.Open FilePath & FileName_EndWith
End Sub