In B4:G4 , I have formulas
They are copied down to B100:G100
I need a Button to REFRESH them !
Since formulas depends on other cells, due to delete, sometime I get #ref! in B5:G100 so I need to got at B4:G4 and copy formula down again
In B4:G4 , I have formulas
They are copied down to B100:G100
I need a Button to REFRESH them !
Since formulas depends on other cells, due to delete, sometime I get #ref! in B5:G100 so I need to got at B4:G4 and copy formula down again
I think it would be better to use robust formulas rather than use code to patch them up. What are the formulas?
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Formulas are super simple
A:B are in Sheet 1, B:G in Sheet2
When I delete a row in sheet1, now I get #ref! in sheet2
Maybe I wasn't clear. What are the actual formulas? What does the formula look like before you delete a row and get #REF?
If you have, for example, =Sheet1!A2, you could use =INDEX(Sheet1!A:A, 2)
If you delete row 2, the first formula will fail, the second won’t.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks