Hi all,
Currently I have the code below, which converts text to columns. I paste the text (with multiple rows) in cell A1 and run the macro.
Sub TextToColumns()
Columns("A:A").Select
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlFixedWidth, _...
I can't set the cell back color for a cell that is hidden via an auto-filter. Does anyone know how to change the cell color without clearing the auto-filter?
Sub SetCellBackColorForAutoFilteredCell()
Dim r As Range
Dim lo As ListObject
Set r = Range("A1:A3")
r.Value =...
Hi All,
Firstly, thank you for your time helping me with my query.
I used Bill Jelen's "Next invoice number" VBA code to help set me up with an invoice template that will generate a new blank invoice and add 1 to the invoice number. My issue is that I have set the first invoice to "SI-00001"...
After reading through several threads on aging formulas, I wasn't able to find a way to achieve the following.
I am looking for a formula that calculates the length of employment based on the anniversary date enter in another cell (D11) on the same sheet. Then a condition that changes the cell...
I have a report that uses colorfunction to differentiate between potential, awarded and lost quotes. Not everyone realises that they must use the exact shades in the legend key, so data is getting left out of the totals. I want to create a dropdown of three particular cell background colours...
Hey all!
I've got a few problems but they're all related to the same thing I'm trying to do, so I'm just going to group them all together in this post. I'm using Windows 7 and Excel 2010. Sorry in advance for the wall of text!
First problem: I'm having a hard time trying to create a custom...
Hi,
I have a field in my excel file that can either be a number or text depending on the adjacent cells value.
Currently I use conditional formating to highlight occurances where non numeric values have been entered in cells that are strictly numeric. The numeric values can be a fraction or...
Hi,
I'm trying to reference a cell's custom numerical formatted result instead of its cell value. For example:
Cell A1 has a value of =.75 and uses custom format "Pass rate: ("0.0%")". The result Cell A1 displayed is therefore:
Pass rate: (75.0%)
I want Cell A2 to refer to Cell A1's...
Hi everyone. I've been having a problem lately. Excel loves to convert any number with a dash or slash in it into a date, and sometimes I really don't want it to. I'm text-to-columning a list of people who are assigned divisions in the format 01-01, and as soon as I do text to columns, it...
Hi Experts,
Is it possible to identify a seaprate line/vbnewline in a cell text.
Example i have the following text in Cell A1:
"I have a brown dog
I also have a black car
I have a nice watch"
If i have the above text in the cell, then i would like to identify from where is the next...
Can anybody help me in number formating
i want to set cell format to 23432/22
Right now my cell custom formating is #,###.00
but i dont need decimal. i need "/"
like #,###"/"00
what shoudl i do.
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.