Our training courses

Other training resources

Our training venues

Why we are different

Details for learningvba

learningvba has participated in the following threads:

Added by learningvba on 14 Oct 2022 at 16:56

Thanks you Andrew!
I totally forgot about the completed file. So, my issue was that I had a line break between each ".End(xlDown) _". I thought this made no difference, but apparently it does :D

 

 

Added by learningvba on 13 Oct 2022 at 05:03

Hello Andy

On step 4, I tried writing the code exactly as displayed, also tried copying the code below.

But I get the error

"Compile error:

Invalid use of property"

I don't understand why...

Could you please help?


 

Sub This_Is_The_End()

 

Range("A4") _

.End(xlDown) _

.End(xlDown) _

.End(xlDown) _

.End(xlDown) _

.End(xlDown) _

.End(xlDown) _

.End(xlDown) _

.End(xlToRight) _

.End(xlToRight) _

.End(xlToRight).Select

 

End Sub

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.

End of small page here
Please be aware that our website uses cookies!
I'm OK with this Tell me more ...