Forum Discussion

Iron Contributor

Aug 23, 2020

Debug Error at "C41:BF & lr"

I get Debug at "C41:BF & lr". Can anyone see a syntax error in my code? Sub Macro25() ' ' Macro25 Macro ' ' Dim rng As Range Dim lr As Integer Set rng = Range("B41:BF3880...

excel

Formulas and Functions

Macros and VBA

office 365

JKPieterse

Silver Contributor

Aug 24, 2020

Greg Bonaparte The correct syntax is:

Range("C41:BF" & lr)

Note the location of the "