-
Hello Paul,
Thanks for that really made my day because I couldn't do it
I tried all sorts of arrays and multidimensional things again and well in the end I just had to copy and paste my VB line 20 times
And I hate having to manually move the text because there was so much of it and
I couldn't find what I was looking for and well I got a bit tired of pasting in the wrong place
Now I can add all the numbers of lines that I need to space out because some bits of text I don't need that much space
But there are other blocks of text that are so condensed that I couldn't see
so those ones need a lot of space so I can now say i want 10 lines without having to make too much of a mess of the text
And when I'm done I can just delete all the empty lines and hey presto it's back to how it was without anyone knowing that I messed too much with the text
well i am a bit clumsy
Well that was the fastest writing code and a new skill that I learnt - to make 3 arrays now
its my new shiny toy thanks so much
Paul and hope you have a great day!!
and forum too
Cheers for your help 
dj
'Extreme VBA Newbie in progress - one step at a time - like a tortoise's pace'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules