Posted to microsoft.public.excel.programming

external usenet poster

Posts: 234

syntax error

I'm trying to select several ranges using a variable (verylastrow) at the
same time to format the items in the selection but I am having a problem. It
must be Friday because I cannot figure out the syntax error in the following
code:

Range("(A1:A & verylastrow), D1:E & verylastrow), (G1:H &
verylastrow)").Select

I'm sure it is something simple but any help would be appreciated. Thanks.
--
JT

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
variable not declared error & syntax error	G. Beard	Excel Programming	1	October 6th 05 09:16 PM
Syntax Error help	Markantesp	Excel Programming	1	March 8th 05 09:51 PM
Syntax error.	David McNally	Excel Programming	3	April 28th 04 02:57 AM
Syntax Error Runtime Error '424' Object Required	sjenks183	Excel Programming	1	January 23rd 04 09:25 AM
Where is my syntax error?	Mike	Excel Programming	2	December 16th 03 10:43 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us