Good day,
I need to copy the visible(filtered) cells "A2:V" from Sheets("Report") and paste below the last row of column "A" Sheets("All Products"). Would you kindly provide code to assist.
Thank you,
Good day,
I need to copy the visible(filtered) cells "A2:V" from Sheets("Report") and paste below the last row of column "A" Sheets("All Products"). Would you kindly provide code to assist.
Thank you,
Last edited by Cannon26; 09-06-2019 at 03:16 PM.
Hi !
You can directly use the Range.Copy method -to see in VBA help - from the global source range as this method works only with visible cells
like you can already test yourself just activating the Macro Recorder and operating manually, a starter to learn …
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks