blank cell

Is there a simple way to select a range from the currently selected cell down to the cell directly above a blank? I'm writing a macro where I've found the first cell in a column that I need, but I haven't figured out how to do a "Shift + Select" down to the cell above the next blank cell. It...

Good afternoon, I am trying to create a Macro to add a blank cell in-between line. Every month when we do this there is no way to know how many lines we will have. Manually doing these I do the following: Number the cells next to the date and auto fill all the way down. Copy the numbers. Paste...

Greetings all - I have looked high and low and can see that a lot of people have asked about how to keep a line chart from plotting blank cells, but I seem not to be able to nail it down in any effective manner. I have a column that is 25k rows. Each cell has a formula that produces a...

Hi All! I've been going through tutorials for the past two days to start my journey in VBA, and need some help for an immediate problem. I currently receive a report from an ACCESS database that I don't have access to, and need to get the data filled correctly so that I can then start using...

I have a worksheet that has a 7 row header (some rows are blank). I am copying data from 3 different tables and need to paste it into the first blank cell after row 7. One thing to note is I also need to be able to specify the column to paste into as the data in the table isn't in the same...

Hello All, I've got a perfectly working Macro assigned to a button to copy paste the contents from one sheet (Designed like a form) to another sheet (Master database - Locked and Protected). This workbook will be shared with many people to fetch data from each. Now, I want my user not to leave...

Hello all! This is my first question ever: I am writing a code in which I use autofilter for option "RET" but in some instances that variable is not present. How can I ask VBA to do nothing if the active cell is blank and to continue with the code if the active cell is not blank...

Hi there, I have a countifs function in sheet 1 of a workbook. This countifs function looks up column AH on sheet 2. Column AH is an if function which returns the name of the person who is working the case reference outlined in col A of sheet 1. If there is no reference in column A of sheet...

HI, I am trying to build a checklist wherein user inputs a string in column A within the following ranges A6:A8, A10:A14, A16:A18 and A20:A23. I can also name these ranges as Sec1, Sec2, Sec3, and Sec4 for easy reference in the code. I am trying to get a vba code that would check if all the...

I have two columns of cells, one with the Due Date and one with the Received Date of certain parts. If the Received Date column is blank, I want to compare the Due Date to today's date and conditionally format the cell if the part is overdue (red) or if it is due within two weeks (yellow). If...

Hello, I try to calculate total amounts with SUMIFS. Sheet Products contains name of products, category of products, release and end date of products and amount information on rows. Sheet Amounts is used to calculate total amounts based on categories. I have couple different criteria and one...

I am importing data from a CSV file into Excel 2016 using Power Query. Cells that should be blank are not truly blank. The columns I am having trouble with are formatted as "Data Type: Text". These columns contain a variety of information and some of the cells are blank. However , when I...

Problem Working with various in-congruent data tables of 100+ columns & 200-500k records, "Clearing Contents" of 'blank cells' takes*: "Blank" Cells Defined - A1:B10; C15:E25; BB2200:BC300000 Ranges contain "blank" cells that Excel counts in Pivot Table summations. - LEN(ranges) = 0 Various...

Hello everyone, I am looking for a way to run this macro on a determined starting point not only on "m3137" but for example if I am in "A3194". It may be worth to mention that I added blank rows to make navigation easier and to have a cell to do the sum. This is the code I used: Sub...

Hi there, please someone help me to solve this problem. I am really confused. I have a reference table like this. <tbody> Category condition 1 condition 2 condition 3 condition 4 A -150 to 140 0 to 15 B 0 to 50 C -150 to 140 0 to 1000 0 to 50000 4.5 to 14 D -150 to...

Hello, need your help. I need VBA If cell in column B is blank then copy and paste it to column A or If cell in column B is blank then cell in column A should be blank too Thank you.

<tbody> ID Vlookups? Col1 Col2 Col3 Col4 1 34 45 2 20 25 29 30 3 10 </tbody> Hi All - I have the following table. First column is an ID. The following columns (ignoring Vlookups) are a number of additional IDs that relate to the IDs in the column. (e.g. IDs 34 and 45 are inputs...

Have two columns, A and B. Trying to get column A's value into column B. I want it so that if column A has a value it lists the value in column B but its blank that it puts "N/A" down. =IF(A<=0,A,IF(ISBLANK(A),"N/A",B)) This seems to not work

I have a table with 3 columns. The table contains formulas in all three columns that returns data. See example below: <tbody> Column B Column C Column D Person # # Alex 5 4 Phil 6 Luke 19 7 John 2 Tori 2 </tbody> You'll notice that after "Tori" there are...

Hi everyone, This is a new one for me, and boy is it frustrating! I am using an Index Match combo using unique ID#s to fill in information from Sheet 1 to Sheet 2... that much I can do! What I can't seem to figure out is why one ID number in the middle of my data set refuses to work. Here's...