Hello,

I am trying to use VBA to insert text into a cell but I keep getting an error. I used

Worksheets("Austin Site Tracker").Range("A" & index).Value = CatalogRange.Cells(catalog, 1).Value

then to just simplify things, I just used

Worksheets("Austin Site Tracker").Range("A21").Value = "Blah"

and it is still giving me a #VALUE! error.

Please help.