data selection

[royboy531]

Is there a way to select cells that only have data in them? trying to write a macro that selects data but the amount of rows changes depending on the day. thanks for any help I can get.

 

[Tazguy37]

How about:

Range("A1:B" & Cells(Rows.Count, "A").End(xlUp).Row).Select

 

[royboy531]

TazGuy, that was perfect. thank you very much for all your help. I am sure I will be posting in the near futer as I am trying to learn new things.
thanks
royboy531