Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with auto Fill
OK here is what I trying to do. I need to count the number of used rows in
column A and place "N" in column AU when there is anything in column A of that row. Im have a major brain Fart here. Dim SourceRange As Excel.Range Dim fillRange As Excel.Range Dim rng4 As Excel.Range With Worksheets("shtXL") Set rng4 = .Cells(.Rows.Count, 1).End(xlUp) If rng4.Row < 1 Then Exit Sub Else Set SourceRange = .Range("AU8") SourceRange.Value = "N" Set fillRange = .Range(SourceRange, .Cells(rng4.Row, "AU")) SourceRange.AutoFill Destination:=fillRange, Type:=xlFillValues End If End With -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200610/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-fill | Excel Worksheet Functions | |||
auto fill or auto search from a list or drop-down list??????? | Excel Discussion (Misc queries) | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
using auto fill edit or fill handel | Excel Worksheet Functions | |||
auto filter and auto fill | Excel Programming |