Hi all,
I've been agonizing for sooo long over a simple thing.
The formula =A1&"XYZ" becomes 22XYZ when I type it myself in a cell (and A1=22 ofcourse)
How can do this formula into a cell with VBA?
Many thanks in advance for your time!!!
Hi all,
I've been agonizing for sooo long over a simple thing.
The formula =A1&"XYZ" becomes 22XYZ when I type it myself in a cell (and A1=22 ofcourse)
How can do this formula into a cell with VBA?
Many thanks in advance for your time!!!
Try:
Obviously, change "A2" as necessary.Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
You should record yourself doing this and then tidy up your code.
Recorded:
Tidied up:Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks!!! Bless you
ShareTheGlobe,
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks