I have three columns I want to perform and find and replace in. I get “Compile error: Duplicate declaration in current scope” and am very new to VBA so not sure what the issue is. Probably something simple if you know what you’re doing. I’ve attached a sample workbook with two sheets “What I Have” and “What I Want” to illustrate what I am trying to achieve with the following code. Thanks for any help.
Please Login or Register to view this content.
Heading can't be a Constant. If you want it to have different values, declare it using Dim and then set the value when you want to change it.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks for the reply. It's honestly a little above my skill without an seeing an example but I did find a solutions that works for me elsewhere making each part it's own Sub statement then using Call in my first Sub statement to call the others. This also helps me keep my scripts segregated so they are easier for me to understand what's going on in each part. i.e...
Please Login or Register to view this content.
Last edited by jambog; 02-15-2021 at 01:55 PM. Reason: Correction
Just this:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks