Posted to microsoft.public.excel.programming

Niklas[_2_] Niklas[_2_] is offline

external usenet poster

Posts: 3

Operator definitions

Hi
I can not find anything about the range operator ':',
union operator ' ' or the intersection operator ','
anywhere in MSDN. I want to know how to use them?

Set myRange = mySheet.Range("I:I,J:J,K:K
11:11,12:12,13:13")
myRange.Value = 1

For example I thought that the above code would put 1 into
the range I11:K13

Best regards
/Niklas

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
Definitions for Activex control properties?	Blue Max	Excel Worksheet Functions	2	December 17th 08 01:15 AM
Properties on Excel Worksheet and definitions	Don	Excel Discussion (Misc queries)	1	January 11th 08 11:38 AM
Sustaining Range Definitions in a Function	hoftenkrabb	Excel Discussion (Misc queries)	1	November 28th 06 03:54 AM
Definitions	Nick	Excel Discussion (Misc queries)	1	July 1st 05 09:25 AM
Need Workbook and Worksheet definitions	nhvwchic	Excel Discussion (Misc queries)	6	May 31st 05 11:48 PM

All times are GMT +1. The time now is 01:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us