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

[Guest]

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.

 

[Guest]

Hi CAPT

in cell A1: =sheet1!$G$4

try =sheet1!$G4

copy A1:C1 down to row 50, but do this in a test sheet!<g>

--
regards,
driller

*****
- dive with Jonathan Seagull

 

[Guest]

D/Driler

WOW. So simple is it. Thanks. I didt realise that i could use it like
$G4. Well the quickest reply I ever got and can consider this thread closed.
brgds/captgnvr

 

[Guest]

nice to hear your thread as in "close"...

i hope also<bg>
--
regards,
driller

*****
- dive with Jonathan Seagull