CTRL SHIFT Down when blank in Range

[cidfidou]

Hi Guys,

Does anyone know the keybaord shortcut to select a range? Indeed, how can i trick excel to use CTRL SHIFT Down in a range with blank data and to select the last data in the range?

Thanks in advance

 

[venkat1926]

why not just write a macro lsomethg like this

cells(rows.count,"A").end(xlup).select

and give short cut key for this macro