I am looking for a way to select information in Columns A, B & C from row 1 down to the last row with information in these columns.
There is information in Columns A, B and C.
- Many of the rows have information but not all rows, there are many blank rows
- At most the rows with information will only be up to row 5,000
- The number of rows with blanks from the first row to the last row with info will vary greatly from each instance this macro is run
I am trying to select from A1:Cxxxx (Cxxxx being the last row with data in in)
- If there is something in Column A, Column B & C will also have info in it
- If there is nothing in Column A then likewise Column B & C will not have info in it.
I have tried this:
Range("A1:C50000").Select
Range(Selection, Selection.End(xlUp)).Select
This just keeps the A1:C50000 selected.
Hope someone can help
There is information in Columns A, B and C.
- Many of the rows have information but not all rows, there are many blank rows
- At most the rows with information will only be up to row 5,000
- The number of rows with blanks from the first row to the last row with info will vary greatly from each instance this macro is run
I am trying to select from A1:Cxxxx (Cxxxx being the last row with data in in)
- If there is something in Column A, Column B & C will also have info in it
- If there is nothing in Column A then likewise Column B & C will not have info in it.
I have tried this:
Range("A1:C50000").Select
Range(Selection, Selection.End(xlUp)).Select
This just keeps the A1:C50000 selected.
Hope someone can help