Greetings,
I have a relatively simple script.
I assign a variant variable using worksheet inputs like:
Later in the script I attempt to use the value of b:
When I check the related sheets I am receiving no value, as if the contents of B10 was empty.
What could be happening here?
I have a relatively simple script.
I assign a variant variable using worksheet inputs like:
Code:
b = ActiveWorkbook.Worksheets("WorksheetName").Range("B10").Value
Later in the script I attempt to use the value of b:
Code:
Selection.Offset(0,1).Value = b
When I check the related sheets I am receiving no value, as if the contents of B10 was empty.
What could be happening here?