I'm trying to accomplish the following:
Sheet1: User clicks a button that runs VBA.
Sheet2: VBA selects the first non-blank cell on column D
Range("D" & Rows.Count).End(xlUp).Offset(1).Select
Sheet1: VBA copies a range of values
Sheet2: VBA pastes the copied range into the active cell selected previously.
This part where I try pasting into the active cell is not working:
Does anyone know how to fix this?
© 2016 Powered by mzan.com design MATCHINFO