Hi friends i have an issue, i use this do loop to fill cells with a certain
text, how i want to choose what i put in "Month i want" and write in columns
C until C reaches the value "total", what i pretend is a inputbox where i
choose what to write.
i think i have to use dim as integer and them define the inputbox with that
dim and then define a msg box to confirm but only have an example for
printing.
Private Sub updatemonth()
Sheets("Brand").Range("C1").End(xlDown).Offset(1, 0).Select
Do
ActiveCell.Value = "Month i want"
ActiveCell.Offset(1, 0).Select
Loop Until ActiveCell.Offset(0, 4).Value = "Total"
End Sub
thank you a 1000 times in advance.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
