Hi,
Assume you have written the formula =2*$A$1 in cell B1. This is a absolute reference. Regardless of to what cell you copy this formula, it will always say: =2*$A$1



A relativ reference in cell B1 would instead be: =2*A1 If this formula is copied elsewhere, it will always refer to "the cell en step to the left". If you copy it to cell B2 it will be =2*A2 in that cell.

If you record a macro with absolut references, it will record exactly in what cells you have been clicking, copying etc. If you use reletive references, it will record "now he moved two rows down and one column to the right", instead of the actual cell references.

Compare the macro code with and without the relative reference and you will notice this difference!

Kind regards
Bjorn

Thks for ur valuable information dude,
ur a genius buddy.