Converting CtrlShiftSpacebar to VBA code
 

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 ***

Converting CtrlShiftSpacebar to VBA code
 

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

Converting CtrlShiftSpacebar to VBA code
 

ActiveCell.CurrentRegion.Select

"Billy Ruben" wrote:

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 ***

Converting CtrlShiftSpacebar to VBA code
 

Just BEAUTIFUL, thanks.

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

Again, thanks a bunch.

"JLGWhiz" wrote:

ActiveCell.CurrentRegion.Select

"Billy Ruben" wrote:

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 ***

Converting CtrlShiftSpacebar to VBA code
 

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.

"Billyruben" wrote:

Just BEAUTIFUL, thanks.

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

Again, thanks a bunch.

"JLGWhiz" wrote:

ActiveCell.CurrentRegion.Select

"Billy Ruben" wrote:

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 ***