Posted to microsoft.public.excel.programming

bhofsetz[_120_] bhofsetz[_120_] is offline

external usenet poster

Posts: 1

Format Borders

Your syntax is off a little on this line

Range("A1:C & NumRows").Select

change it to

Range("A1:C" & NumRows).Select

HT

--
bhofset
-----------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...fo&userid=1880
View this thread: http://www.excelforum.com/showthread.php?threadid=39099

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Borders	Larry L	Excel Discussion (Misc queries)	2	August 11th 09 05:45 PM
Conditional Format Borders	clark-ee	Excel Discussion (Misc queries)	1	October 26th 08 01:21 AM
Borders	DAH Mist	Excel Discussion (Misc queries)	0	October 1st 07 10:24 PM
Format cells with borders	Jim	Excel Discussion (Misc queries)	3	June 10th 07 02:24 AM
Borders	linda	Excel Discussion (Misc queries)	0	January 25th 05 05:31 PM

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

About Us

"It's about Microsoft Excel"