PC Review


Reply
Thread Tools Rate Thread

Converting CtrlShiftSpacebar to VBA code

 
 
Billy Ruben
Guest
Posts: n/a
 
      28th Nov 2008
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 With Quote
 
 
 
 
Jim Cone
Guest
Posts: n/a
 
      28th Nov 2008
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
 
Reply With Quote
 
JLGWhiz
Guest
Posts: n/a
 
      28th Nov 2008
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 With Quote
 
Billyruben
Guest
Posts: n/a
 
      28th Nov 2008
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 With Quote
 
JLGWhiz
Guest
Posts: n/a
 
      28th Nov 2008
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting code ADO VBA to ADO net VB.net Gum Microsoft ADO .NET 2 19th Aug 2009 10:27 PM
Needs help converting some pseudo code into VB code williameis Microsoft Excel Programming 2 21st Dec 2006 07:46 PM
Help converting C# code to VB =?Utf-8?B?UGhpbGw=?= Microsoft VB .NET 4 22nd Jun 2006 07:14 PM
Converting vb code to C# Stephen Microsoft C# .NET 1 18th Jan 2005 01:29 PM
Help converting this code from vb6 to vb.net? Steve Microsoft VB .NET 11 22nd Jan 2004 10:14 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:32 AM.