Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check row above for information if it has contents copypaste empty
I am trying to get this macro
For Operation = 2 To Cells(Rows.Count, "B").End(xlUp).Row If Len(Application.Trim(Cells(Operation, "A"))) < 1 Then Cells(Operation, "A") = "Examine" Next Operation To perform these steps Check each row in Column A for data If the row contains data do nothing If the row does not contain data check the row above it for data. If the row above it has data enter the text €˜Closed into the empty row. However, it will only work if data is in another Column but the same Row not the same Column another row. Can you help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select all rows till last row with value in Column A and CopyPaste | Excel Programming | |||
Delete rows if AF and AY empty but F has information | Excel Worksheet Functions | |||
CopyPaste | Excel Programming | |||
FormatConditions appears to kill copypaste | Excel Programming | |||
VBA code need help on CopyPaste | Excel Programming |