Posted to microsoft.public.excel.programming

Matt[_33_] Matt[_33_] is offline

external usenet poster

Posts: 78

How can I use a variable as cell address?

this causes an error:

SelectedCells = Union(SelectedCells, CheckCell.Range("A1:B1")

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
insert contents of variable cell address	Charlie@ParkViewTerrace	Excel Discussion (Misc queries)	1	June 30th 09 11:28 PM
can chart title be linked to variable cell address?	dmhittner	Excel Discussion (Misc queries)	5	February 3rd 07 07:54 PM
Can the column index in a cell address be made variable?	cyberdude	Excel Discussion (Misc queries)	1	November 20th 05 02:47 AM
Select Cell based on Variable address	achidsey	Excel Programming	2	September 17th 05 06:47 PM
Setting a variable cell address	Hugh Jago	Excel Discussion (Misc queries)	3	January 5th 05 03:45 PM

All times are GMT +1. The time now is 10:08 AM.

About Us

"It's about Microsoft Excel"