+ Reply to Thread
Results 1 to 3 of 3

Repair a macro

  1. #1
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    774

    Repair a macro

    Good evening all and anyone.

    Part 1

    Attached is my file and on the "Master" page there is a a hidden code ( Shown below ) that "Sintek" created for me last week initially it was to create blocks of data on the " Master " sheet dependent on how rows of data was associated with the Call sign that was entered in cell " C1 " on the " Master " sheet it would create between 1 and 6 blocks of selected data ( NOT ALL CELLS are SELECTED ), however I have now learned that in some cases I could have up to 10 or more rows of data for that call sign.

    I have shrunk the panels down and adjusted the font accordingly , so if possible could the code the adjust number of panels up to 10, a sample of the call sign for VK2RAG data is below.

    Please Login or Register  to view this content.
    Here is the Code that "Sintek" created to fill the blocks as required..


    Please Login or Register  to view this content.

    If I have not made myself clear enough please advise.


    Peter
    Last edited by Potholes; 05-20-2019 at 10:47 PM.

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: Repair a macro and create a new one

    The original Hidden formular done by " SINTEK " (Which I am forever grateful to), On the Master sheet when I entered VK2RAG into "C1" there is al least 12 lines of data to select from, be displayed on the Master sheet when I enter that particular callsign, IT is currently only displaying 5 cells of data...
    For part 3 refer to your original thread which has not yet been marked as solved...The file in Post30 solves...
    In future please address any issues with code provided within the thread it refers too...
    https://www.excelforum.com/excel-pro...ml#post5120943
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: Repair a macro

    Hi Potholes

    This should be a Forum rule...
    Please do not delete or edit posts after other members have responded...This just causes confusion as the responses initially made do not make any sense...I will not be posting here as this thread is now closed lol...Please continue in your original thread...
    https://www.excelforum.com/excel-pro...ml#post5120943

+ 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. Error and Repair query
    By Andy Swain in forum Excel General
    Replies: 0
    Last Post: 08-07-2017, 04:39 AM
  2. [SOLVED] Repair unique value
    By sanju2323 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-10-2016, 08:17 AM
  3. How to repair Excel.
    By parkman in forum Excel General
    Replies: 2
    Last Post: 03-04-2014, 05:12 PM
  4. Repair Shop Scheduler
    By andrewdugas in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-20-2013, 06:34 PM
  5. Document repair keeps comming up
    By jjjgroot in forum Excel General
    Replies: 6
    Last Post: 11-29-2012, 06:06 AM
  6. open & repair through vba
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2006, 10:45 AM
  7. [SOLVED] excel file repair
    By Jerryfromvisalia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2005, 09:05 AM

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