check and replace $

How to check or replace all refer to address column are assigned (eg. data2, 4) in formula column E (formula1) make sure add with "$" (e.g. $B??, $D??)

e.g.
A B C D E
data1 data2 data3 data4 formula1
53.5 54.25 50.75 52.25 =SUM(B4:E4)/4
47.9 47.9 44.4 45.1 =(B5+E5)/2
45.5 45.5 39 41.9 =E6
43.1 43.5 40.8 41.8 =(C7+D7+E7)/3
45.5 47.2 45 47 =E8/2+B8/2
48.4 49.6 47.5 48.3 =B9
... ... ... ... =various
etc.

Hi, patel45, thanks for your reference, but I want apply to column B & E only [i.e. address(ColumnAbsolute:=False)] not for all and rows, how to do it? thanks

Originally Posted by patel45

Please Login or Register  to view this content.

I only change the code [ToAbsolute:=xlAbsolute] to [ToAbsolute:=xlRelRowAbsColumn] for all column, but I have not ideal how to set required column(s)??

Originally Posted by alee001

I only change the code [ToAbsolute:=xlAbsolute] to [ToAbsolute:=xlRelRowAbsColumn] for all column, but I have not ideal how to set required column(s)??

Finally, I solved the problem about absolute required column(s) by following code:

Please Login or Register  to view this content.