+ Reply to Thread
Results 1 to 1 of 1

Code for search and print

  1. #1
    Forum Contributor
    Join Date
    09-18-2014
    Location
    Χαμένος στο διάστημα
    MS-Off Ver
    2016
    Posts
    383

    Code for search and print

    Hi, i think that i need big help here.
    I have a sheet named Numbers which it having an area with numbers, and a sheet named Form with a range for printing. In this range, cell E13 is for numbers from sheet Numbers, and cell D11 is for type of each number. Now, may i have a button, and when i click on it doing the following,
    look at the sheet Numbers for the first number and put it to cell E13, and in D11 put the type of this number, and print the range B2:M73 from sheet Form.
    Then again for the second listed number etc
    This needed to be made for all numbers that exist in the range in sheet Numbers.
    Is this possible?
    Thanks in advance.
    Attached Files Attached Files
    Nick

+ 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. Code for search and print
    By Immortal2014 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2016, 02:45 PM
  2. VBA Code - Search text & search number & search qty and result - Urgent Please
    By naresh73 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2014, 10:51 AM
  3. Replies: 1
    Last Post: 01-30-2014, 05:38 PM
  4. Correct VBA Code to Print Defined Print Area
    By newqueen in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-27-2014, 04:31 PM
  5. Code and Formula to print dynamic print area ranges
    By stpeter in forum Excel General
    Replies: 1
    Last Post: 10-15-2013, 03:33 PM
  6. [SOLVED] Need ‘Set Print Area’ Code for Dynamic Print Range based on Conditions
    By dosbirn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2013, 12:13 PM
  7. [SOLVED] Print array code for a series of pages that will also determine print area required?
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2012, 11:46 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