Hi,
Trying to get this formula to copy down column AD for the entire dataset and getting an error "Method "Range' of object' _Global' failed.
Just curious what I'm doing wrong here![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Code:
Range("AD2:AD" & LastRow).Formula = _
"=IF(RC[-1]=""Y"",""Specialty"",IF(RC[-2]=""Y"",""Retail 90"",IF(RC[-4]=""R"",""Retail"",IF(RC[-4]=""M"",""Mail"",""""))))"
Trying to get this formula to copy down column AD for the entire dataset and getting an error "Method "Range' of object' _Global' failed.
Just curious what I'm doing wrong here
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)