Posted to microsoft.public.excel.programming

DavidC[_2_] DavidC[_2_] is offline

external usenet poster

Posts: 44

Variable usage in Range Command

Help please

When using the Range("B1:B50").Select I want to
substitute a variable into the Range.

I have a variable which is a number e.g test=50

Therefore the command I want is
Range(B1:B'test'").Select

I cannot get the syntax right.

Idea is to select a range of data based on variables.
Is this the right way?

Cheers
David

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Public variable usage!	Tom Ogilvy	Excel Programming	0	April 14th 04 03:34 AM
Public variable usage!	chris.	Excel Programming	0	April 13th 04 09:56 PM
Public variable usage!	chris	Excel Programming	0	April 13th 04 09:51 PM
freeze pane command usage	mark kubicki	Excel Programming	2	March 4th 04 11:13 PM
Command Usage	john petty	Excel Programming	1	September 6th 03 04:52 PM

All times are GMT +1. The time now is 08:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us