Macro to copy over cell value rather than actual cell (code included)

[jayinthe813]

Please Login or Register  to view this content.

This copies over a daily count and exports it into a file so that the user does not have to do it daily, as is, it works fine, but I might need to re-tweak it due to drive availability issues. What I would like to do is instead of copying B21, copy the value of B21, because right now it is pulling the formatting as well, when I just want the value. Any ideas?

[patel45]

Please Login or Register  to view this content.

[jayinthe813]

thanks, I made the mistake in not using .value for both sides, kept erroring. +rep

[patel45]

no mistake, they are 2 different ways to make a copy

range(source).copy range(dest)
or
range(dest).value = range(source).value