when I try to compile .Offset(, 1) gives an error ? WHY ??? Is offset not supported ? Syntax error on 1 in the bracket (red line underneath)
Set rngNumbers = Range(“B2”, Cells(Rows.Count, “A”).End(xlUp).Offset(, 1)
var = Application.Transpose(rngNumbers.Offset(, -1))
Range(“G2:G” & Rows.Count).ClearContents
May I email it to you - I need some help to get the macro protected -will buy software if I can get macro protected as its the heart of my sheet.Plse advise
Your code looks strange. Even in VBE it triggers errors. Please check it.
To access all Excel objects, you must generally put Application. before. For instance, Application.Range(...)
Copy this in your compiler and see what I say…works flawless in VBA but NOT in your compiler
Set rngNumbers = Range(“B2”, Cells(Rows.Count, “A”).End(xlUp).Offset(, 1))
var = Application.Transpose(rngNumbers.Offset(, -1))
Range(“G2:G” & Rows.Count).ClearContents
Ok noted I have emailed you the whole Macro SampleNew -I need to get it protected -the macro is called GetCombosReversed
Looking for your reply on your contact email -info@
Thank you
John
The problem comes from the syntax parsing here:
Set rngNumbers = Range(“B2”, Cells(Rows.Count, “A”).End(xlUp).Offset(, 1))
The compiler has a mismatch because it doesn’t recognize End as being an object but rather it expects End XXX such as End Sub. We’ll try to fix that in a future release.
Otherwise, for Offset(, 1), you should replace with Offset(0, 1)
