Myself Anoop Balagopal From India
I am using a Transpose Function in formula,formula as follows
How can I get the sheet name ( here sheet names are ML1 and G20 ) dynamically.
Please Login or Register to view this content.
If I change the sheet name in the excel I will run this macro and will get the formula automatically.
Thanks In advance
Last edited by AliGW; 07-31-2019 at 01:00 AM.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however you need to include code tags around your code.
Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.
Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(Note: this change is not optional. As you are new here I have done it for you this time.)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hello AliGW
Thank you for the info.Will keep in mind for next time
Hi,
I suggest to loop through the sheets
then activate the desired sheet then:
Please Login or Register to view this content.
Hello mohadin
I did the code which you have mentioned but unfortunately it didn't work out.
The code which I did is
But in the formula bar it is showing asPlease Login or Register to view this content.
I have hard coded the formula as belowPlease Login or Register to view this content.
I have to Implement a Tranpose formula in Sheet one ( Data to Transpose will be from Different Sheets)Please Login or Register to view this content.
Last edited by anoopbalagopal; 07-31-2019 at 04:26 AM. Reason: Re format
You have already been advised about CODE TAGS in post #2: please add them to post #5.
No further help to be offered, please, until this has been done.
Edited.Took Time to understand.
Sorry for this
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Hello bakerman2
It worked.
Thank you very much.
Code as follows
Please Login or Register to view this content.
Hi Anoop,
sorry it was my mistake
but any way
Please Login or Register to view this content.
You're welcome and thanks for rep+.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks