# inches

1. ### Adjust Row Height & Column Width in Inches

I am trying to size my rows and columns by inches, instead of pixels and cannot get it to work. I went to Options>Advanced>Display and changed the default to inches. When I type in these options I get an error message....1/4, 1/4 in, .25 in. Error message - Your entry cannot be used. Am...
2. ### Count the occurrences of rainfall over 2 inches within a two day period.

I have a table with date in column A and amount of rainfall in column B. In column C I need to count if there is an occurrence of rainfall over 2 inches in a consecutive two day period. If the rainfall does exceed 2 inches it is counted and the calculation starts over for the subsequent days...
3. ### Count the occurrences of rainfall over 2 inches within a two day period.

I have a table with date in column A and amount of rainfall in column B. In column C I need to count if there is an occurrence of rainfall over 2 inches in a consecutive two day period. If the rainfall does exceed 2 inches it is counted and the calculation starts over for the subsequent days...
4. ### Converting values from MM to Inches in multiple cells and multiple workbooks

I am new and have never worked with macros. I have 30 different workbooks with cells that have their values in MM and I want to convert all of them to Inches. I will eventually have to do this with a few hundred workbooks. All the workbooks have the cells that need to be converted in the same...
5. ### inches millimeters in the same cell

I am trying to take 2 feet in cell A1 and in A2 show inches (millimeters) that it is 24 (609.6). I know how to do it in separate cells but trying to combine it in one cell. This is for approximately two hundred rows so I wanted to automate the formula.
6. ### How to format cells to show ' and " for feet and inches

I would like to enter 12 5 in a cell and have them return 12'5" as a result. I don't know how to enter the formula in the format cells dialog box. Any help would be appreciated.
7. ### Working with Inches/fractions

Hi, I have this program that reads a number of cells which have some measurements in inches with the following cell format # ??/?? so i get te following results (all numbers rounded to 1/16): 58 58 1/4 3 1/16 etc 13 3/8 when the macro reads the cell it reads it as decimal. 58 58.25 3.0625...

### This Week's Hot Topics

• VBA (Userform)
Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
• List box that changes fill color
Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
• Remove duplicates and retain one. Cross-linked cases
Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
• VBA Copy and Paste With Duplicates
Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
• Macro
is it possible for a macro to run if the active cell value is different to the value above it
• IF DATE and TIME
I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...