This is part of my code here:
Dim ord As Range
Dim pub As Range
Dim prid As Variant
Set xyz = Rows(13)
Set ord = Sheets("Image Catalog").Range(xyz, ("AA:AF"))
Set pub = Sheets("Image Catalog").Range(xyz, ("AD"))
Set prid = Sheets("Image Catalog").Range(xyz, ("AC"))
I want the ROW NUMBER to be referenced as "xyz" in my code.
But DEBUG error comes up and highlights THIS portion when the MACRO is run.
Set pub = Sheets("Image Catalog").Range(xyz, ("AD"))
I think it's because THIS part is written wrong:
I don't know how to correct it!
Thanks!
Bookmarks