Hi,
i have code like here:
which throws an error about type.
Please Login or Register to view this content.
It is possible to assign to string array range?
Or i have to loop?
the purpose to have array as string it to not loose leading zeros while outputting variant array.
Thanks!,
Best,
Jacek
You have to loop.
Everyone who confuses correlation and causation ends up dead.
Re: How to put range into redimed array?
Hi,
as it has no sense to allocate the ranges values to a dimed array - like allocating an useless Range variable as well ! - but
if you really need it then yes just use a loop …
Hello. Two equivalents to what you've tried but didn't work for you would be:Originally Posted by jaryszek
Please Login or Register to view this content.
You are always very welcome if you add reputation by clicking the * (bottom left) of each message that has helped you.
Neither of those approaches will give you a String array though.
run your 'test' macro in attached file.
Please Login or Register to view this content.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
Please Login or Register to view this content.
Last edited by jindon; 11-28-2022 at 10:32 PM.
Wow thank you Guys!!
Awesome i am taking your ideas to my project!
Best,
Jacek
Thanks for the +rep.
@jaryszek, thanks for the feedback and added rep point.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks