how can i use this
with
=If(B30="-";"Not in use";If(B30=Opsjon!A2;Opsjon!G16;If(B30=Opsjon!A3;Opsjon!N16;If(B30=Opsjon!A4;Opsjon!U16;If(B30=Opsjon!A5;Opsjon!G37;If(B30=Opsjon!A6;Opsjon!N37;If(B30=Opsjon!A7;Opsjon!U37;"Start over")))))))
I have this macro that copies a few cells. I need all B30 references to change to B31 while all other stays the same.Sheets("Sheet1").range("G31").Formula = ""
Use dollar ($) signs to make the cell references absolute, as you would on the worksheet itself.
Better to post all the code and a ample workbook than just odd lines out of context.
Regards, TMS
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
Addnew.xlsm
Here you have a file.
hope you understand what i want.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks