Forum Discussion
Using ClearContents on a Range Defined with Variables
I am trying to ClearContents of a range of cells using Variables AND text to define the range. I have the following code : Set WithdrawalsRange = WBSC.Range(WBSCCol.Row & "F:" & WBSCCol.Row & "AY")...
The range should be F4:AY4 instead of 4F:4AY, so use
Set WithdrawalsRange = WBSC.Range("F" & WBSCCol.Row & ":AY" & WBSCCol.Row)