Friday, 14 July 2017

excel - Declare cells or range as variant in VBA

It would be very basic question.



I want to declare cells as variant, to substitute repeated typing, like



a = cells(1,1)
or
a = range("a1")



then

a.select or
a.value, etc..



but error occur with




runtime 424




I want to understand what is problem, and how can i do.




Thanks,

No comments:

Post a Comment

casting - Why wasn't Tobey Maguire in The Amazing Spider-Man? - Movies & TV

In the Spider-Man franchise, Tobey Maguire is an outstanding performer as a Spider-Man and also reprised his role in the sequels Spider-Man...