Forum Discussion

Bill3203's avatar
Bill3203
Copper Contributor
Jan 08, 2026

.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

Resources