I must have messed up the vba syntax here but I can't figure it out. The error is in the last line. Any help would be appreciated!
RangeName = InputBox("Enter the name you used to define the data from the last sheet imported. (Must be exact!)")
ActiveCell.Offset(1, 0).Select
ActiveCell.Formula = "=countifs('[" & RangeName & "]'!,WTX)"
RangeName = InputBox("Enter the name you used to define the data from the last sheet imported. (Must be exact!)")
ActiveCell.Offset(1, 0).Select
ActiveCell.Formula = "=countifs('[" & RangeName & "]'!,WTX)"