specialcells range

  1. J

    VBA Macro - Select range of SpecialCells

    Hello, I'm doing a VBA macro button for automatizing some filtering and copying of new data from an Excel book/query (wb1) to another book refering to a client (wb2) with the latter's format. More specifically, I look for the last value in column 3 of wb2 and save it (I name it 'prt'), I...
    • JGR
    • Thread
    • excel macro specialcells specialcells range specialcells().copy vba
    • Replies: 1
    • Forum: Excel Questions
  2. J

    Special Cells - Delete Visible Rows using VBA code. Run time Error 1004

    Hi, Thanks for your time. I am trying to run the below macro code and have no issues till the last line (Macro 2) where all i want is to delete visible rows (special cells). The last step either runs for 10-15 mins to complete the action or throws out at error (Runtime error 1004). Also if...
  3. C

    Unintended SpecialCells count result in non-contiguous range

    Excel 2010 I'm trying to ensure there's a blank row between ranges on a worksheet by creating a non-contiguous range derived from a column on the worksheet known to have data and looping through the non-contiguous range. As soon as I hit a range that is only one row the SpecialCells count...
  4. C

    Excel 2010 / Win 7 / VBA: Feed a SpecialCells range into an Array for UserForm ListBox use

    I have two spreadsheet columns of non-contiguous data. Column B is the "key" column. VBA rng1 consists of cells where there is text in Column B cells. Trying to create VBA rng2 which consists of rng1 cells and the adjacent Column A cells. Next is to then populate two array columns with each...
    • CtrlAltDel2X
    • Thread
    • listbox range to array specialcells range userform listbox vba array
    • Replies: 4
    • Forum: Excel Questions

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