hello
i have two sheets with name "TO." and "TOTAL"
i have sheets("TO.").range("C4").vlaue = 1
and
i have sheets("TOTAL.").range("B4").vlaue = 1
I Want to change both 1 with "B" automatically using running macro
thanx
hello
i have two sheets with name "TO." and "TOTAL"
i have sheets("TO.").range("C4").vlaue = 1
and
i have sheets("TOTAL.").range("B4").vlaue = 1
I Want to change both 1 with "B" automatically using running macro
thanx
Last edited by HaroonSid; 05-12-2014 at 10:52 AM.
range("c4").replace("1","B",xlLookAtWhole)
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks