| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting formulas to code | New Users to Excel | |||
| Converting code to function | Excel Programming | |||
| Converting EasyLanguage code to Excel | Excel Discussion (Misc queries) | |||
| Needs help converting some pseudo code into VB code | Excel Programming | |||
| UDF problem in converting data into code 128 B | Excel Worksheet Functions | |||
Linear Mode
