varies

  1. Y

    Rename pictures in a particular cell

    I have pictures on range F7 in all sheets. unfortunately the names of the picture varies in all the sheets. how do i give it a uniform name like "mypic"
  2. R

    Validation

    Hello, I am trying to create a validation for a specific syntax. Example: BP:402865 The BP: is fixed but the 6-digit number varies. Could you please help with a formula that I can use in the validation? Thank you
  3. C

    Need help in solving the below scenario

    I am trying to write a formula for the below conditions B1 value varies based on that I need to get output in C1 using below condition If B1>70 C1 should be 40 If B1>0 & <70 C1 should be 20 If B1<0 C1 should be 0 If B1=Exempted C1 should be Null If B1=Not Reached C1 should be Null
  4. G

    help with dynamic autofill

    I have concatenated info from two other columns, in cell A9 and Im having trouble figuring out the VBA to autofill dynamically until the corresponding column B is at its end, which varies. Can anyone assist? This is getting inserted into a larger macro I have.
  5. R

    Removing specific characters from a string

    Hello, I need to remove the first two, and the last five characters of a string, but the length of the string varies. Can someone help me get started? The dataset has about 130,000 rows Thanks!
  6. R

    Fixed X Axis w/ Variable Range

    Here's one I haven't seen: How do you, using VBA, create a fixed number of x-axis tick marks (say, 10), even if the data range varies? I have the following, but it doesn't seem to work: objChart.Axes(xlCategory).CategoryType = xlCategoryScale...
  7. E

    Indirect function

    I have a cell reference that varies. I tried to use the indirect function, but I keep receiving error message as volatile. Pl help!:( This is my original formula (this formula is at worksheet2, worksheet1 is supposed to be left untouched as it is a copied worksheet from another workbook)...

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