empty cell

Hi, I am in the middle of testing my first attempt at using VBA code and to my dismay am running into difficulties. I have used the following VBA code in a For loop to check for empty cells in a spreadsheet: If Cells(i, 1).Value <> "" And Cells(i, 13).Value <> "" And Cells(i, 20).Value <> 0...

I am trying to select all blank cells. im not sure how or why (must be a result of lots of copy/paste) many of my blank cells are not highlighted when I do the function: find>go to special>Blanks>OK not sure how to fix this problem....the spreadsheet is huge and i need to select and delete...

I need some help on writing a code that finds any empty cell in a range ("Q4:Q46") and then cuts the cells ("A:P") in that same row and paste it to another sheet starting with cell ("A4"). Then delete the rows that the data was cut from. This code will be linked to a command button. Any help...

Hey Guys I've been having some problem figuring this one out. I have an excel file with quite a bit of data and I need to be able to cut rows from sheet 1 into sheet 2 based on wether or not column G is blank. (if it is blank I need it moved). Any ideas how VBA handles blank cells? That...

As an A Level ICT Student, I have been told to push my spreadsheet to as high a standard as I can. I've been asked to find out how to create an Error Message that will show up if a cell is empty when a button is pressed, as we have created an input form type set up. Simple solutions would be...