Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How do I edit a referenced cell within a formula- for multiple cells simultaneously in excel?
The referenced cells are located on a different worksheet and when I try to record a macro using the relative cell fxn opening a formula means that I loose the reference cell on the sheet from which i need to copy the data. so, is there another way to do this w/o a macro. Or, if not, then is there a way to record or write a macro that will do this using relative cell values? thanks
4 Answers
- Anonymous1 decade agoFavorite Answer
I couldn't understand your question well.
But:
I guess this VBA line will help you,
Range( "D6").FormulaR1C1 = "= Average( r[-3]c1:r[-1]c1)"
Now, when you check cell D6 for that function, it will show this:
=AVERAGE( $A3:$A5)
So, :
$A in Excel, is c1 in FormulaR1C1
3 in Excel is r[-3] in FormulaR1C1
5 in excel is r[-1] in FormulaR1C1
So, you may edit your macro based on these info to complete your work
Good luck
Enjoy my profile, I am the VBAXLMan
- bigrick45Lv 41 decade ago
If I understand you correctly, you can select all the worksheets while holding the ctrl button (or right click and "select all sheets") and any changes made on one worksheet in a cell will be in effect on all selected sheets. That will work if all the cells on the various worksheets are in the same location.
- 1 decade ago
If the two answers above don't help, I think it's because your question isn't clear. Try giving a simplified example of what you are trying to do, using actual cells and formulas.
