visible cells paste

  1. L

    Cut and Paste Data in a Filitered Range

    Hi, I'm pretty new to VBA and I would like to cut the data available below the header column from columns L to S and paste it in Columns D to K in the same sheet. Please note that it is a filtered range and the data should be cut from and pasted in the visible cells only. Also, please note that...
    • lifesgood
    • Thread
    • cut paste data autofilter excel & vba macro vba visible cells paste
    • Replies: 1
    • Forum: Excel Questions
  2. W

    Pasting visible cells only not working due to size and shape mis-match

    Hi, I am using Excel 2010 and am copying visible cells only to a new spreadsheet so that I can work on a sub-set of data I have been given. I can copy the visible cells only fine, but when I try to paste the selection in a new spreadsheet it won't work and says I have a size and shape...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top