avoid hidden rows

  1. J

    Drag Formula Down and ignore hidden/invisible rows

    Hello all, I am trying to write a macro that filters a sheet and uses formulas like SUMIF and Vlookup to replace the existing columns. I need to find a way to drag down the formulas without affecting the hidden/ invisible cells in vba. I would really appreciate any help and suggestion. Here is...
  2. B

    Macro to copy a range of merged cells into only rows which are visible

    Hi All, I'm new here so apologies in advance if I overstep on the etiquette or for showing my ignorance. I am really hoping you can help - my specific problem is as follows: I have text data in merged cells on columns B to D for each row from 200 through to 213 (so 14 rows total). I would...
    • Bekzii
    • Thread
    • avoid hidden rows excel & macro merged cell as range ranges
    • Replies: 2
    • Forum: Excel Questions
  3. A

    Export worksheets from multiple workbooks into pipe delimited txts

    Hi, I am new to this forum and am hugely impressed by the skill level of the experts here at VB. I am currently stuck by a problem with details as below. I need to develop an Excel 2007 macro to: - Ask the location of the folder where approx 40 excel files are located (each excel workbook has a...
    • anshul03
    • Thread
    • avoid hidden rows avoid hidden worksheets dir. by workbook name wrkbks to delimited txt
    • Replies: 1
    • 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