+ Reply to Thread
Results 1 to 9 of 9

cell replace from range and print sheet

  1. #1
    Registered User
    Join Date
    07-04-2012
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    14

    cell replace from range and print sheet

    I have a main sheet and a names sheet and i wanted to replace cell b37 from sheet1 with a different name from a worksheet "names" and go down the list until it reaches a5. your help and time is really appreciated.


    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862

    Re: cell replace from range and print sheet

    Attach your workbook with data and a before & after example of what you're trying to achieve. This will clarify the requirement and not require us to guess at your data and spend time recreating it from a description.
    MatrixMan.
    --------------------------------------
    If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
    If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.

  3. #3
    Registered User
    Join Date
    07-04-2012
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: cell replace from range and print sheet

    SCORE SHEET

    Date _______________


    Time ________________

    Re RG2018 Elem School 5-E
    AM Khaver Room 406

    (b37) Name "where the macro will replace the name and print it "

    Color Level _________________+/-


    Errors ________________________________


    SHEET "NAMES"

    A

    1. JAMES Q
    2. BOB M
    3. GAIL y
    4. JANE D
    5. JOSE F


    So it should take a name from the sheet called names from range a1:a5 and place the information into b37 and print it


    my code so far

    Please Login or Register  to view this content.

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: cell replace from range and print sheet

    Maybe try...

    Please Login or Register  to view this content.
    HTH
    Regards, Jeff

  5. #5
    Registered User
    Join Date
    07-04-2012
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: cell replace from range and print sheet

    thank you that worked great!

    what would I put so that it stops once the cell has no names in it?

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: cell replace from range and print sheet

    The macro will stop once it gets to 5.

  7. #7
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862

    Re: cell replace from range and print sheet

    I think he means to stop sooner if (say) A4 is empty:
    Please Login or Register  to view this content.

  8. #8
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,497

    Re: cell replace from range and print sheet

    Hope devil20a catches the different names for his sheets. Small and Capital letters.

    Or from 1 to however many are in Column A in "names" sheet.

    Please Login or Register  to view this content.
    Last edited by jolivanes; 05-10-2019 at 03:42 PM. Reason: Add code

  9. #9
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862

    Re: cell replace from range and print sheet

    Oops ... nice pickup ... although yours might still include blanks
    Please Login or Register  to view this content.

+ 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. [SOLVED] Macro that will print/save as PDF with file name a cell, replace cell and repeat
    By JasonNeedsHelp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-04-2018, 04:59 PM
  2. [SOLVED] Vba to print range but on different sheet
    By HereComesTheBoom in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2017, 06:53 AM
  3. [SOLVED] Replace Cell Value From Range Then Print Worksheet
    By BillyRaySpivy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-06-2017, 11:02 AM
  4. Scan barcodes, replace cell with next one after print action
    By MaliExcel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2014, 07:36 AM
  5. [SOLVED] automatic replace sheet names based on new cell text (within defined range)
    By Robert1311 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-08-2014, 05:37 AM
  6. VBA to set print range, open box asking for print qty, print, then redefine print area
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2012, 06:43 PM
  7. Replies: 1
    Last Post: 11-24-2005, 07:29 AM

Tags for this Thread

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