Apologies - I haven't done VBA in years and have got very rusty.
I want to use the variable 'wordplace' to put the contents of C18 (some text) into cell R8 when a macro is run.
'wordplace' starts at 0 and is incremented each time the macro is run. I have got that working.
So the next time the macro runs, the contents of C18 go into R9, then R10, R11....
I then have a column of words from R8 downwards.
Can anyone help?
Please see yellow banner on how to attach a sample workbook.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Please show the code you have so far. Show all of the code. Use CODE tags. Even better, just attach your file (see yellow banner at the top of the page)
Maybe
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks Trevor, that worked perfectly!
I made an Excel version of Wordle.
wordle.jpg
Last edited by 6StringJazzer; 02-05-2022 at 08:45 AM. Reason: fixed image attachment
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks