visible cells

  1. opazzo

    VBA Auto fill visible cells

    Hi there, Must be something wrong with the syntax as I get a runtime error 1004 : "Autofill method of range class failed". Here is my code : Range("X6").FormulaR1C1 = "=IF(ISNA(RC[16]),"""",RC[16])" Range("X6").AutoFill Destination:=Range("X6:X" & Lastrow).SpecialCells(xlCellTypeVisible)...
  2. A

    Filtering multiple sheets

    I know that when you 'Group' sheets that filtering doesn't work but is it possible to mark on a second tab whether a row is visible or filtered out on the original tab? The idea being that I don't want to have to repeat a complicated filtering exercise on the second tab - I just want the result...
  3. O

    Select and copy cells that aren't blank

    Hi Guys, I'm not sure where to start, so I have no code at all. I get many workbooks each week with the same format - data in columns A and B. But the number of rows will always vary. I want to make a macro that will select and copy only the cells with data into them into another workbook...

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