Hi all,
Is it possible to have VBA copy and paste a range of data that is using a formula to a new worksheet as values? Currently when I try doing this, I get #REF! errors in the column.
This is some sample data I'm using that has the formula in the cell:
and then this code is grabbing it:Please Login or Register to view this content.
I'm sure there's a much better accomplishing the above, but this is what I have cobbled together thus far. Thanks for the help!Please Login or Register to view this content.
Bookmarks