Rockymtnhigh
Board Regular
- Joined
- Feb 2, 2009
- Messages
- 83
Would like to convert this array formula to vba so I can run as macro:
{=REPT("0",MAX(LEN($B$2:$B$349))-LEN(B2))&B2}
Also, any way to make it dynamic as there may be less than or greater than B349?
Thank you.
{=REPT("0",MAX(LEN($B$2:$B$349))-LEN(B2))&B2}
Also, any way to make it dynamic as there may be less than or greater than B349?
Thank you.