| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Don't Copy If Null -- Help
I have generated a code with help of macro's that will select a range
and then Auto fills it to a given range. It all works fine with one exception. What I really like to do is stop copying the formula if there is no values in Column A, in other word do copy until cell in Column A is Null, Starting from A3. Range("C2:BL2").Select Selection.AutoFill Destination:=Range("C2:BL43"), Type:=xlFillDefault Range("C2:BL43").Select A B C D E F Etc ----------- 1 NAME Formula Formula Formula 2 Name Ardy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
| COUNTIF says Null = Blank but Blank < Null | Excel Worksheet Functions | |||
| Null, "null", vbNull, vbNullString, vbEmpty | Excel Programming | |||
| Copy contents of Cell to array based on Col1 value not null | Excel Programming | |||
| copy cell with non null value | Excel Programming | |||
Threaded Mode
