Hi.
I have a small problem with this code. I want it to increase the cell reference as it runs through the cells like when you type in a formula in one cell and copy it to the cell below or next to it changes the cell reference to match the new.
Example:
=If(data!A1=1;1;0) will change to =If(data!B1=1;1;0)
But i dont know how to add this to the macro - here is my attempt:
Thanks in advance!Please Login or Register to view this content.
Bookmarks