Posted to microsoft.public.excel.programming

John V[_2_] John V[_2_] is offline

external usenet poster

Posts: 33

Simple Range Syntax Question

Right now, I have the following line of code in a macro:

Range("B6:B129").FormulaR1C1 = _
"=YEAR(RC[-1])&TEXT(MONTH(RC[-1]),""00"")&TEXT(DAY(RC[-1]),""00"")"

Now I want to generalize the reference to select, starting in cell B6, a
range that is X rows long and Y rows wide (X and Y determined elsewhere).

How to I change this code? Thanks, John

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
question about syntax in a simple macro...	Dave F	Excel Discussion (Misc queries)	3	November 3rd 06 02:12 PM
Range Question (very simple)	narutard[_4_]	Excel Programming	0	July 14th 05 07:52 PM
Simple question - Named Range in Macro	wammer[_6_]	Excel Programming	1	August 25th 04 12:39 AM
Simple range reference question?	Mike	Excel Programming	6	February 26th 04 08:04 PM
need help with simple syntax error	Gwill	Excel Programming	1	July 15th 03 08:24 AM

All times are GMT +1. The time now is 09:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us