Converting CtrlShiftSpacebar to VBA code

[Billy Ruben]

An area has X number of rows by Y number of columns containing data.
Selecting the topmost filled cell at the leftmost column and using the
keyboard sequence CtrlShiftSpacebar, selects the whole area that
contains data. What is the VBA code equivelant? Thanks



*** Sent via Developersdex http://www.developersdex.com ***

 

[Jim Cone]

Did you mean to say: Ctrl + Shift + *
--
Jim Cone
Portland, Oregon USA



"Billy Ruben"
wrote in message
An area has X number of rows by Y number of columns containing data.
Selecting the topmost filled cell at the leftmost column and using the
keyboard sequence CtrlShiftSpacebar, selects the whole area that
contains data. What is the VBA code equivelant? Thanks

 

[JLGWhiz]

ActiveCell.CurrentRegion.Select

 

[Billyruben]

Just BEAUTIFUL, thanks.

What's a good source for finding VBA equivalents to Keyboard Shortcuts?

Again, thanks a bunch.

 

[JLGWhiz]

I find most of mine in the VBA help files. Just press Alt + F11 to open the
VBE and use the help search box to look for keywords for whatever you are
interested in. Sometimes the microsoft term is not what you think it should
be, so you might have to use the trial and error method for some of them.
You also might want to spend some time browsing the manuals that are included
in the help facility. Click the big arrows above the search box to display
the manuals. There should be at least three of them, one for Office, One for
Excel and One for Visual Basic Language Reference. These manuals are helpful
in learning the different categories of code for VBA as well as how to write
the code.