Re: Auto Fill with VBA code
Ok. I did what you said and it worked down to like row 5006 but then did nothing after that.
Posts by superiorsvc
-
-
Re: Auto Fill with VBA code
Sorry trying to learn VBA code. I'm sure it's probably something I'm doing. I click on visual basic editor. Double click the name of my sheet and new window comes up. I copy and pasted this: With Range("C1:C1000").SpecialCells(xlCellTypeBlanks) .Value = .Offset(-1, 0).Value
End WithThen exit out and click run macros - nothing happens.
-
Re: Auto Fill with VBA code
Doesn't work.
-
Re: Auto Fill with VBA code
Row 2 - Row 36855
-
If Column A is not blank for that row - then I want to hide that entire row. Would like VBA code to do this for the whole sheet again. Range rows 1-36855.
-
In Column C I have what you see below. I want autofill so that the two blank cells under 12345 will fill with the same 12345 and so on for the entire sheet. The numbers do change as you go down the page as they do here. Every two or three or five blanks is a new number. [TABLE="width: 500"]
[tr]
[td]12345
[/td]
[td][/td]
[/tr]
[tr]
[td][/td]
[td][/td]
[/tr]
[tr]
[td][/td]
[td][/td]
[/tr]
[tr]
[td]45678
[/td]
[td][/td]
[/tr]
[tr]
[td][/td]
[td][/td]
[/tr]
[/TABLE]