variable field location

  1. D

    place text in a variable location in row

    Hello Forum - i have a production scheduling spreadsheet that has color fill on each line to indicate a range of times that have been calculated (it shows as a color bar on a calendar of weekdays - say 2pm on Wed thru 6pm on Thu). It's all working fine, but now I want to be able to place a text...
  2. M

    VBA script copy cell based on value in column

    Hi, I have an Excel spreadsheet that has 3 columns and thousands of rows. The value in the third column indicates which row to copy. I am looking to copy the value from column A to column D if C has a value. Then based off the number in C copy the value from A to E EXAMPLE: -- removed...
  3. T

    Excel VBA Help with Declaring Variables

    I am getting an object required error for some of my declared variables not sure how to correct it. I probably have more errors than this too if anyone can help me out it would be appreciated I don't have much experience in VBA. Dim i As Integer, j As Integer, k As Integer Dim x As Range, y As...
  4. 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...
  5. C

    delete sheets with contain variable names

    I need to create a macro that will delete all sheets in a workbook that do NOT contain the substrings "Dec" and "09". All other sheets in the workbook may contain some variation of the months of the year (e.g. October 09, Sept 09, Jan. 09, etc) Some workbooks will contain 2 or 3 sheets with...
  6. KG Old Wolf

    AutoFilter issues (2)

    First Question: All, I need to enter a macro area and be able to force the autofilter off. Using Selection.AutoFilter only toggles me back and forth - I need to be sure it is off Second Question: I need to be able to select a field that will vary in location within the spreadsheet...

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