Posted to microsoft.public.excel.programming

RVic

external usenet poster

Posts: 3

Reference a row programmatically

If I have a column A, of data, as follows:

34
76
57
21
7
15

and I want B1 to reference A1, B2 to reference A5, B3 to reference A9 (I am incrementing by 4) how do I specify this in the formula for column B?

Thank You, RVic

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
Setting VBA reference programmatically	Nicholas Dreyer	Excel Programming	3	October 19th 06 03:49 PM
programmatically Set Reference to Library	Todd uttenstine	Excel Programming	6	April 30th 04 10:55 AM
Programmatically Add Reference`	keepitcool	Excel Programming	1	September 16th 03 05:30 PM
Programmatically Add Reference`	Jean-Paul Viel	Excel Programming	0	September 16th 03 02:23 PM
Can i set a reference programmatically?	Tom Ogilvy	Excel Programming	1	August 19th 03 04:24 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us