Posted to microsoft.public.excel.programming

Tempy

external usenet poster

Posts: 203

Setting a Range name

Good Day, I have to name a range and it can vary, dependant on the
spreadsheet recieved and the amount od data but all the used area will
be the range name KTL.

At this point in time it is A1:CQ847

This could go to CQ5000

Could somebody help me with some code please.

Thanks in advance

Tempy

*** Sent via Developersdex http://www.developersdex.com ***

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
Excel Addin:Setting the range to the Excel.Range object range prop	Rp007	Excel Worksheet Functions	5	November 24th 06 04:30 PM
VBA setting Range	Jeff	Excel Discussion (Misc queries)	1	December 2nd 05 07:36 PM
Setting a Range	Tempy	Excel Programming	6	June 15th 04 03:46 PM
range setting	Mike Harris	Excel Programming	5	November 22nd 03 05:07 AM
Setting a range using VBA	[email protected]	Excel Programming	4	November 14th 03 05:16 AM

All times are GMT +1. The time now is 03:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us