Posted to microsoft.public.excel.programming

stefantem[_9_] stefantem[_9_] is offline

external usenet poster

Posts: 1

Problem setting a range

set col = Sheet2.Range("A1:Z1")
for each c in col.Cells
...
set arie
Sheet2.Range(Cells(1,c.Offset(0,0).Column()),Cells (100,c.Offset(0,0).Column()))
(doesn't work)
...
nex

--
stefante
-----------------------------------------------------------------------
stefantem's Profile: http://www.excelforum.com/member.php...fo&userid=1359
View this thread: http://www.excelforum.com/showthread.php?threadid=27037

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
problem setting the used range for a column	Janis	Excel Discussion (Misc queries)	2	January 17th 08 01:04 PM
Excel Addin:Setting the range to the Excel.Range object range prop	Rp007	Excel Worksheet Functions	5	November 24th 06 04:30 PM
Problem setting SeriesCollections source range	Lead Foot	Charts and Charting in Excel	2	January 27th 06 05:11 AM
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 05:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us