| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill until Null
Hello,
I am having an issue with what I would believe to be an easy issue. I'm trying to have column AU (starting a row 8) autofill with "N" untill the same row in column A is null. Below is what I have been to use but it doesn't want to work. Any thoughts on this would be much appreciated. Thanks. Dim rng4 As Range Set rng4 = Worksheets("shtXL").Cells(Rows.Count, 1).End(xlUp) If rng4.Row < 8 Then Set rng4 = Worksheets("shtXL").Range("A8") Set rng5 = Worksheets("shtXL").Cells(Rows.Count, 3).End(xlUp) rng5.AutoFill.Value = "N" -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200610/1 |
| 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 | |||
| Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
| Q. Autofill question: Can I autofill alpha characters like I can numbers? | Excel Programming | |||
Threaded Mode
