lordterrin
Board Regular
- Joined
- Mar 21, 2012
- Messages
- 155
Hi There,
I am working in a filtered worksheet, and I'm having problems with the autofill command.
Column A is blank, and I need to fill it in based on how column C is filtered.
I've gotten as far as correctly filtering this and putting the word "Yes" into cell A6 (where the worksheet starts), but when I try to autofill down, I can't figure out what command will do this on a filtered range.
I can't use
because I don't know the absolute value to put in as it will always be variable
and I also can't use
because it will then fill everything, which is obviously wrong.
I tried the most logical conclusion:
but that doesn't exist in Excel for some stupid reason, so I got an error.
How do I do what I'm trying to do?
I am working in a filtered worksheet, and I'm having problems with the autofill command.
Column A is blank, and I need to fill it in based on how column C is filtered.
I've gotten as far as correctly filtering this and putting the word "Yes" into cell A6 (where the worksheet starts), but when I try to autofill down, I can't figure out what command will do this on a filtered range.
I can't use
Code:
Range("A6").AutoFill Range("A6:A[I][U][B]something[/B][/U][/I]")
because I don't know the absolute value to put in as it will always be variable
and I also can't use
Code:
Range("A6").AutoFill Range("A6:A" & ActiveSheet.UsedRange.Rows.Count)
because it will then fill everything, which is obviously wrong.
I tried the most logical conclusion:
Code:
Range("A6").AutoFill Range("A6:A" & ActiveSheet.[B]VisibleRange[/B].Rows.Count)
but that doesn't exist in Excel for some stupid reason, so I got an error.
How do I do what I'm trying to do?