Looking for help in code change

[santoshloka]

i have to change code manually every time to work my code

 browobject.document.getElementById("mapDatum").Value = "1"
        browobject.document.getElementById("utmZone").Value = "[U][COLOR=#b22222]43[/COLOR][/U]"  [COLOR=#0000ff]---->' "=B3"[/COLOR]
        browobject.document.getElementById("utmHemi").Value = [U]"[COLOR=#b22222]N[/COLOR][/U]"   [COLOR=#0000ff]---->' "=C3"[/COLOR]

Find the red color in my code, is it possible to give cell reference instead of giving value manually all the time please help me save my time

I am trying to change code like Blue Color in my code,its not taking reference

SHEET1
B3=43
C3=N

 

[Special-K99]

Does this work?
(I doubt you need to place quotes everywhere)

browobject.document.getElementById("mapDatum").Value = 1
        browobject.document.getElementById("utmZone").Value = Range("B3")
        browobject.document.getElementById("utmHemi").Value = Range("C3")

or possibly

browobject.document.getElementById("mapDatum").Value = 1
        browobject.document.getElementById("utmZone").Value = Cells(3, 2)
        browobject.document.getElementById("utmHemi").Value = Cells(3, 3)

If you use the second piece of code you can change the first 3 and replace it with a variable from a loop, as I suspect that's what you probably want next.