+ Reply to Thread
Results 1 to 4 of 4

Simple changes in macros required

  1. #1
    Forum Contributor
    Join Date
    02-15-2016
    Location
    India
    MS-Off Ver
    2016
    Posts
    657

    Simple changes in macros required

    Hello

    (1) In the attached excel in Sheet 1
    In the below macro and attached excel macro file i need a simple change. 100 numeric input should be maximum value of column A:A. This is because everytime inside VBA code i need to change this per populated date. Instead if the macro automatically sense the maximum value of column A:A then without touching macro code i can control in the excel sheet itself.
    Something like this required.

    (2) In the attached excel in Sheet 2
    The attached excel file macro is capable of copy the cell content E124 to G124.
    But the requirement is need to copy the cell contents from L2 to G2 and need to format by macro.
    From L2 to G2 need to go upto LN to GN where N is the maximum value in Column A:A.

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Thanks in advance

    Sekar
    Attached Files Attached Files
    Last edited by Sekars; 05-18-2022 at 10:47 AM.
    Sekar

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,392

    Re: Simple change in macro required - Input by macro code instead of value

    Administrative Note:

    You have been a member long enough to know our rules!

    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. No help to be offered until this moderation request has been fulfilled.)
    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.

  3. #3
    Forum Contributor
    Join Date
    02-15-2016
    Location
    India
    MS-Off Ver
    2016
    Posts
    657

    Re: Simple change in macro required - Input by macro code instead of value

    I have updated my post per your comments.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,392

    Re: Simple change in macro required - Input by macro code instead of value

    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to get input box with required values
    By raviprakash369 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-15-2017, 11:46 PM
  2. i want to have a macro code change based on input from a textbox in a form
    By Jenkins27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2015, 07:24 PM
  3. excel fromula or macro required to do simple job
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-15-2013, 10:45 AM
  4. Simple MACRO to delete words not required in ROWS
    By soni77 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2011, 10:58 AM
  5. simple copy paste macro required
    By normanjones4 in forum Excel General
    Replies: 2
    Last Post: 02-27-2007, 12:00 PM
  6. Help required to run simple macro...
    By londonchick in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-22-2005, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1