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"
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
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
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.
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!
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...
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 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.