Quote Originally Posted by arnelgp View Post
ok if you want to go that path, it's fine.
i only want to share you what i have using
vba. i created a Public sub addRowNumber() in Module6.
it will put record# to sheet "Record (2)" (for demo).
Arnelgp
I hope I don’t get in trouble with the forum moderator but I haven’t gotten a response from other and I don’t have any patience. I tried your new code and it works just as I wanted and placed it in my real-world worksheet with one modification (worksheet name). THANKS
Question though….I use worksheet code names instead of the worksheet name and may use this on other sheets with same format. How would I adapt the code?
Again THANKS