empty

Hi Everyone, I've posted a similar question, but am having new troubles. One column has 4 values, T12, T8, empty cells, and #VALUE !. The second column has values 1 through 4. The new column needs to take the value from the second column (numbers 1-4) and match it to a title. For example, if...

Hello, I have the following code to sort through three different columns. If Column 5 is empty, it needs to be filled in with the specified color. However, there are times that column 5 may not be empty. When there are no empty cells in column 5, it turns all three columns(5,6,7) all blue. How...

Hello, I am having trouble figuring out the code to do the following: If the data in column A says "Internal" and column B is empty then I want column B to fill with: cell.Interior.Color = 16776960 If there is data in column B, I don't want it to do anything. If the data in column A...

Column A in the Rows of my worksheet either contain a date or are empty. I need a method that would sort the column the lists cells that contain dates and that contain no date.

Hello Team, I need your help with a formula to calculate how many empty column between of the letter “A” as in the row#2. The result that I am looking for should be the same as in row#1 as shown below. Any help would be greatly appreciated. BDT <tbody> A B C D F G H I J K L M N O P Q R S T...

Hi All, I need some major help haha. I'm a total newbie to VBA, started out of necessity. I need to write a function that when data from sheet 1 is inserted to sheet 2 it looks at that new data and if the cell above it is empty it moves the cell up until no empty cells remain. So essentially...

Hello- I am constantly receiving the error "Regression Input range contains numeric data" when using the regression analysis in the data tool pak. I have performed a data validation check to ensure no non-numeric values exist. This error is only occurring on the regression, not correlation...

I have a code that is able to Append a range of data in a worksheet to an existing CSV file. However, I noticed that when the existing CSV file contains empty, but formatted cells beyond the end of the data range, the Append function takes into account those empty cells as well. For example...

This is my formula which works great if all cells are populated. However, when either L7 or L8 are empty I get the classic #VALUE error. How do I get the equation to ignore blank cells? =((N5-(L7+L8))/N5*1)

Hello,</SPAN></SPAN> I need to remove empty rows from column C and rearrange Num column B </SPAN></SPAN> Original Data</SPAN></SPAN>...

I have this code that plots points on a graph. It works reasonable well except, it plots empty spaces that coincide with the weekends (Sat & Sun) (ex 06/07-06/10). Not sure why it does this, but I would like the chart to be seamless (Don't plot the empty spaces). Is this possible? Thanks...

I have an Excel formula that I put together to consolidate the content of a whole grid of cells into minimally formatted bullet lists. However I have had to cut it off before the character limit. What I am doing is taking data exploded into discrete elements and pulling it into a cell, to...

Morning all. I found the below code to fill a selected range that has empty cells amongst the data to fill the blank cells with whatever input into the resulting pop up box, in this case zero. It works on part of the worksheet but not on the other, I cannot understand why it will not work on...

I'm no Excel expert -- so forgive me if I use the incorrect terminology. In a report I've created using Excel, there is a cell that is to produce a conditional value. The formula I've written for the cell is as follows: =IF(CalcSheet!F58>1,"low agr",IF(CalcSheet!F58>=0.6,"mod agr","high...

Hi all, I have added a checkbox, CheckBox1, to a sheet. When checked, I am trying to send the values of E29 and D29 to the first empty row, to columns A and C on a sheet called Sample. Any help would be greatly appreciated. Thanks, Chris

Hi, I am looking to insert a new checkbox into the next empty cell. I can get this far, but then can't specify the properties of the box. See below: ActiveSheet.OLEObjects.Add "Forms.CheckBox.1", Left:=1206, Top:=(Range("T" & Rows.Count).End(xlUp).Offset(1).Top) + 2.25, Width:=12, Height:=12...

Hi, I m trying to paste only the value from a merged cell ("C10:K10"), to the next empty cell in column N. The code I am using unsuccessfully is below: Range("C10:K10").Copy Range("N" & Rows.Count).End(xlUp).Offset(1).Select ActiveSheet.PasteSpecial xlPasteValues...

Hi All, I need some assistance. I'm VERY new at this. I've created a report, where I use data from Sheet 1 to populate some of the cells in Sheet 2, column B being one of them I'm not sure how I want to go about this. But I want the row to be hidden if the B cell is empty on Sheet 2. So if...

Hey All! I have a report with a pivot table on it; it will expand and contract depending on the data selected. I'd like to create an EMPTY table immediately to the right of it, that expands and contracts to the same size of the pivot table. I've google it, but I'm not finding what I'm...

Hi I have userform which has 3 text boxes. I want to add 2 numbers and put the result in the 3 box when I click on + command button. Everything is working fine but if I only entered one number in first box and left the other box empty and then press + button, I get error message. How can I...