| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check to see if cell is blank
I want my macro to first check & see if A9 is blank. If it is I want to
paste copied data in A9, if it is not blank I want to proceed with finding the 1st blank cell in column A and pasting there (which is how the macro is set up) Range("A9").Select Selection.End(xlDown).Select ActiveCell.Offset(rowOffset:=1).Activate ActiveSheet.Paste Columns("D:D").EntireColumn.AutoFit |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting - check for blank cell | Excel Discussion (Misc queries) | |||
| Want to check if cell is blank before running macro | Excel Programming | |||
| check to see if a cell is blank if not populate adjacent cell wit. | Excel Discussion (Misc queries) | |||
| Need macro to check if cell is not blank & previous cell is blank, copy information from row above & paste | Excel Programming | |||
| How to check if a cell is blank and, if so, apply a formula | Excel Programming | |||
Threaded Mode
