select from activecell to a specific range

[Pedro Alves]

hi ppl,


i have a table range from A1 to AH85 (A1 to AH is merged) and i want to select only cells (activecell) with data on the table.

So, let´s suppose that the activecell is on A25, then i offset to 0, 33 and i reach the AH column, but how can i select from A1 to my offset selection?

thanks in advance!

 

[Pedro Alves]

Ive made it lol.....

Range(ActiveCell, ("A1")).Select

omg looks easy now ^^

Thanks anyway ppl. HF.