Required
1 re-repeating number 100 in column A
Without pulling down cell
ineed that by formula , no code
I think I reached resolve in the sheet (AA 2)
Required
1 re-repeating number 100 in column A
Without pulling down cell
ineed that by formula , no code
I think I reached resolve in the sheet (AA 2)
Last edited by mahmoud-lee; 05-31-2013 at 09:02 PM.
=IF($B$2>=(ROW($A$2:$A$380)-1),$C$2,"") would be a much simpler approach
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Ingenious solution and beauty of simplicity
If I want the solution by code?
Code:Sub RepeatValue() Range("A2:A" & Range("A" & Rows.Count).End(xlUp).Row).ClearContents Range("A2").Resize(Range("B2").Value).Value = Range("C2").Value End Sub
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
you are very kind thanks a lot
Posting Permissions
Reply With Quote
Bookmarks