VBA Code for doing a Cntrl+Shift+Home

[sukhdevs]

Can someone help me with VBA Code for doing a Cntrl+Shift+Home. I want to be able to do select content from anywhere in my last column to first cell in spreadsheet because my my macro deals with spreadsheets that have the same number of columns/columns but have different number of rows. Thanks.

 

[Fluff]

Why not try recording a macro & see what it gives you?

 

[alansidman]

Sub CtlShftHme()
    ActiveCell.Select
    Range(Selection, Cells(1)).Select
End Sub

 

[sukhdevs]

Thanks Alan. It worked perfectly. Appreciate your help.