changing formulas

  1. W

    Macro that will change multiple cell references to one cell below on another sheet

    Hi I have been trying to work through this macro based on other posts I have found but I am very new to this and couldn't make it work. It think this should be very easy but I just can not figure it out. I have to generate several hundred invoices by hand, and I have the fields that I need...
    • wangs930
    • Thread
    • changing cells changing formulas macro shifting formulas vba
    • Replies: 5
    • Forum: Excel Questions
  2. S

    Macro Question, Importing data from a report & end value changes every time

    Hi all thanks for any help offered. I am trying to create a macro for a report that im doing. at one point in the report i have to put the range field into a pivottable and pivot chart wizard. which comes as 'rawdata'!$A$1@$I$1085 the end 4 digits (1085) will change reflecting the last row...
  3. T

    Excel changes case in formulas against my wishes

    I am using a 3rd party Excel Add-on that uses javascript to convert Excel spreadsheets to HTML. There are several formulas with this add-on that relies on formulas being case sensitive. For instance, I want the formula to say =wwsHideRows but then Excel automatically changes it to =wwshiderows...

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