variable number of rows

  1. T

    Code for find and replace with autosum (upwards)?

    Here's what I have (Ignore the x's, etc., they're just to show blank space): <C>xxxxxxx_123_XXXXX xxxxxxx_____XXXXX xxxxxxx_456_XXXXX xxxxxxx_789_XXXXX --------------------- 101112 Total 131415 </C> Is there a way to find and replace that word "Total" with something like autosum going...
  2. B

    Working with a variable Range

    My MACRO is used daily to copy data from several sheets resulting in a new sheet with a differing number of rows with every run. My problem is that I need to define this range of rows in order to do an AUTOFILL function. I know I can use a cell to hold the row count using COUNTA. However, I...
  3. M

    Filtering Problem in VBA

    Hello Everyone, I am new to this forum and I tried to find a similar thread, but couldn't find one addressing my issue exactly. I am using Excel 2003 and I have a worksheet that contains about 3000 rows and is updated daily. I filter the worksheet based on different criteria and save a...
  4. F

    How to make a function only apply to a variable number of rows containing data

    I'm writing a macro to apply some simple functions (copy, paste, sort, etc) to a sheet of data. My problem is that the number of rows in this sheet will vary for each occassion I want to apply the macro. Can someone please tell me how to instruct a function to first calculate the number of...

Watch MrExcel Video

This Week's Hot Topics

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
Top