I need some help with copying and pasting through VBA
Posted by Kevin on January 16, 2002 9:02 AM
Right now in VBA I have the following code:
Range("A1").Value = Range("B1".Value)
I use this code as a means of copying whatever is in cell B1 into A1 whenever the macro is run. However, I need it to also copy the format of B1, as well as any data validation criteria that is setup in B1, to A1. Right now all it pastes to A1 is the value. Can this be changed to suit my need?