Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Null Rows
Hello,
I am exporting data from Access to Excel. This part works great. I have the values exported to a worksheet. I then link those cells to a formatted worksheet within the workbook. Since the data from Access is dynamic, I don't always fill up the formatted sheet. Therefore, I would like to delete any blank rows within the range of rows 9-150 on the formatted sheet when the workbook is poened. I've used a "Delete Row" macro before but for the life of me, can't figure out how to do this again. I would like a macro to look for blank values in column A between rows 9 and 150. I will be looking for blank values in column A to determine whether the row stays or gets deleted. I have an IF statement for the value of the cell which states that if the imported data (on the seperate sheet) is blank, then the value of the cell will be blank. One thing I tried to do is select the range A9:A150. I then pushed F5 and tried to search on special and blanks. Even though some of the cells were blank (based on the if statement), the results said there were no blank cells. Would anyone have any idea how to write a macro to delete rows if the results of the formula are null? As well, I have one additional question (it's a little bit Access related). When I export the data from Access to Excel, I use a form. There is a "start date" and an "end date" field on the form. I would like these values to appear in specific cells within the Excel Workbook. Any Ideas for this one? Thanks in advance for any help, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Null/Blank Rows | Excel Discussion (Misc queries) | |||
Deleting Cells where content equals "0" or null | Excel Programming | |||
Deleting Null Cells | Excel Discussion (Misc queries) | |||
How do I pick up only the rows with a non-null key column on a separate sheet? | Excel Worksheet Functions | |||
Global hiding null rows | Excel Discussion (Misc queries) |