Sub blah()
For Each cll In Selection.Cells
cll.Offset(, 1).Resize(, 2).Value = GetPrice(cll.Value)
Next cll
End Sub
Through this macro I can update name and price. right?
What I do is just add new url on cell A5 and, in cell B5 entered =GetPrice(A5) and press CTRL+SHIFT+ENTER but showing #VALUE! error, what wrong I am doing?
can anyone build VBA code for name and price extraction from URLs in column A into column B and C respectively?
best regards
▬▬▬▬▬▬▬▬▬ Mod edit : thread closed as duplicate !