Posted to microsoft.public.excel.programming

Fred[_21_] Fred[_21_] is offline

external usenet poster

Posts: 18

How can I rewrite this using an Array?

Thanks Tom, much cleaner...

But what if I did not want to specify my ending column. In this case I
needed 56 columns so I counted over manually to find the 56th column.
But what if I wanted the 213th column.

I was thinking an Array for this: Range("A1:BD1").

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
vlookup [rewrite]	Janis	Excel Discussion (Misc queries)	0	July 25th 07 10:36 PM
How to Rewrite these Code?	hce[_18_]	Excel Programming	0	September 29th 04 09:33 AM
How to Rewrite these Code?	hce[_17_]	Excel Programming	1	September 29th 04 04:16 AM
How to Rewrite these Code?	hce[_16_]	Excel Programming	1	September 29th 04 03:33 AM
How to Rewrite these Code?	hce[_15_]	Excel Programming	1	September 29th 04 01:22 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us