Home Excel VBA Subscription out of range
Reply: 0

Excel VBA Subscription out of range

user343 Published in May 20, 2018, 12:01 pm

I only have 2 simple lines and Excel VBA keeps telling me Subscription out of range... why?

Sub try_again()

'Dim res As Variant
Dim Per_Mnd As Variant
Dim Per_Mnd2 As Variant

Per_Mnd = Worksheets("Res_Lege").Range("F41:AD41")

Worksheets("Res_Kontor_over").Range("F6:AD6").Value = Per_Mnd

End Sub
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.31736 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO