Forum Discussion
Bill3203
Jan 08, 2026Copper Contributor
.range in VBA with equation
There may be other ways to solve this. I want C3 to be a dropdown list, when I run the macro I want to grab the selection and move it to wsdatabase. However, it moves the entire dropdown list. My solution was to make F3=C3 for when the macro runs. Using the below, however, I get #REF! in wsdatabase. IF F3 is just data it is fine. How can I make this work if F3 is an equation?
wsinput.Range("f3").Copy wsdatabase.Range("A" & nextrow) 'Copy date
No RepliesBe the first to reply