Thanks ide...but there is a syntax problem with your code.
It gives me an expected error on the line
Range(Cells(1, ActiveCell.Column)).Address).Activate
Are u sure this is the correct syntax for thia command.
Thanks
Kajal
I am sorry about the question i asked earlier. I was a liitle confused. what i need to know is the number of non empty rows in a specific column.
Thanks
Kajal
I am sorry about the question i asked earlier. The thing is that i am not trying to get the last cell in a column...but instead i need to count how many non empty cell are there in the column.
Thanks
Kajal
I just wanted know how can i get to the last cell on a certain column in an excel spread sheet...its not the last cell of the worksheet but the last cell of a certain column.I would appreciate it if anyoone could help me with the code
Thanks
Kajal
Hi
I hope someone can help me with this.
I am trying to merge certain columns from different spreadsheets in excel into one spreadsheet.Which is the most efficient way of doing this.I'm sure there is a better method than copy pasting each time.
All suggestions are welcome
Thanks
kajal
Hi
I am new to VB and was wonderin if anybody could help me with this.... I have a variable which i have stored in a cell in an excel worksheet. The problem is when I try to call that Variable using a macro in a formula somewhere else in that sheet it gives a NAME? error. I am basically just...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.