Saturday, 7 December 2019

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

php - file_get_contents shows unexpected output while reading a file

I want to output an inline jpg image as a base64 encoded string, however when I do this : $contents = file_get_contents($filename); print ...