Here is what I am trying to do. I want to autonumber like this
1F
2F
3F...
ALSO
JPG1F1
JPG2F1
JPG3F1...
Is there a way to do this.
Thanks
Last edited by VBA Noob; 10-09-2008 at 04:32 PM.
Maybe
and=ROW(A1)&"F"
VBA Noob="JPG"&ROW(A1)&"F1"
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Exactly what i needed.
Thanks
Does that function auto number all the way down or do you have to use the fill down function ?
I told you Ryan, if one gets through, its a Victory. (Trevor Howard to Frank Sinatra: Von Ryans Express - 1965)
You have to fill down the formula.Originally Posted by GeoffCoates
Edit:
Also, per forum rules, please do not "hijack" an existing thread.. please start a new thread and refer to another if you feel it will help...
Last edited by NBVC; 06-10-2009 at 11:16 AM.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks