VB code to copy a row with absolute cell ref and also relative cel

Posted to microsoft.public.excel.programming

CAPTGNVR[_2_] CAPTGNVR[_2_] is offline

external usenet poster

Posts: 87

VB code to copy a row with absolute cell ref and also relative cel

DEAR ALL
For ex:

in cell A1: =sheet1!$G$4
in cell B1: = M20 * N20
in cell C1: = Q20 * SHEET1!$F$2

Is it possible to copy the range a1.c1 till row 50 using fill down and the
result should be like this.

in cell A2 : =sheet1!$G$5 (THIS ABSOLUTE SHOULD CHANGE FROM $G$4 TO $G$5
AND SO ON.

in cell B2 : = M21 * N21

in cell C2: = Q21 * SHEET1!$F$2 (THIS ABSOLUTE SHOULD NOT CHANGE)

I am using excel 97. Pls help.

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
can i copy a hyperlink with absolute and relative references	june.sidwell	Excel Programming	0	December 27th 06 06:31 AM
Excel: Cant copy an relative Cell and make absolute	themantheworldlovesmorethannathan	Excel Discussion (Misc queries)	1	August 22nd 06 11:26 PM
How do I copy an absolute column and relative row to the right?	Fusterated	Excel Discussion (Misc queries)	1	March 23rd 06 08:49 PM
macro to copy absolute cells, then paste relative	Bill Carr	Excel Programming	1	November 16th 04 10:42 PM
record macro - copy absolute, paste relative	Bill Carr	Excel Programming	0	October 27th 04 10:41 PM

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

Menu

About Us