Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kajal
  • Order by date
  1. kajal

    last cell of a column

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

    no of rows in a column

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

    last cell of a column

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

    last cell of a column

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

    Merge Excel files

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

    Using Variable

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

Part and Inventory Search

Back
Top