Hi, I'm very new to VBA so apologies if this is a simple question. I was using a macro to capitalize all strings in two ranges. The current code I'm using looks like this:
Dim x As Range
For Each x In SuppliesList.Range("B" & FilledRows + 1, "C" & SourceRows + FilledRows)
x.Value =...