Guys,
If I highlight a group of cell say from F4:H25 and in each cell I have a different formula how do I when the range is highlighted make each cell formula an absolutre reference i know pressing F4 will do it to one cell but it does not spread it across the range of cells highlighted any ideas?
you need vba
just select the cells and then run the macro
sub makeAbsolute() for each rcell in selection rcell.formula = application.ConvertFormula(rcell.formula, xlA1, xla1, xlabsolute) next rcell end sub
Josie
if at first you don't succeed try doing it the way your wife told you to
OMG I love this little bit of code. Awesome! Thank you so much.
This link perhaps?
http://www.excelforum.com/excel-gene...-of-cells.html
Alf
Try this... say you have, in cells D1:D4 -
D1: =A1*B1
D2: =A2*B1
D3: =A3*B1
D4: =A4*B1
And you want to absolutely reference B1 in all 4 formulas. Select cells D1:D4, go into the formula bar, change the B1, to $B$1, then hit Ctrl + Enter.
- Moo
Thanks everyone thats great!
How would I change to $A4:$B9 or if i wanted to change the cell formula to =($v4-$g4)/10 can I change the code to do that somehow?
change xlabsolute to xlRelRowAbsColumn
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
chriswiec 
Register To Reply
Bookmarks