Hi Excel Gurus,
I am novice with VBA. I have created a macro through recording macro and modified it using my little knowledge of VBA, however this macro is taking too much time.
The macro is just pasting a formula in each cell of a range and pasting that cell as values.
Can someone please review this macro enhance it performace.
Thanks,
Please Login or Register to view this content.
Charm
You don't need to loop through each cell. Try:
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...
Many many thanks, Olly
This is lightning fast
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks