Results 1 to 2 of 2

VBA printing

Threaded View

  1. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,661

    Re: VBA printing

    No sample file + vague explanation = confused. But, maybe:
    Option Explicit
    Sub Inbox()
        Dim GetRng As Variant
        GetRng = InputBox("enter first and last separated by comma")
        GetRng = Split(GetRng, ",")
        'Looping the through each row
        For i = GetRng(0) To GetRng(1)
        '...
    End Sub
    Last edited by protonLeah; 05-16-2024 at 07:30 PM.
    Ben Van Johnson

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 04-17-2021, 05:08 AM
  2. Replies: 1
    Last Post: 06-11-2014, 09:23 AM
  3. Replies: 0
    Last Post: 02-27-2014, 01:31 PM
  4. Replies: 0
    Last Post: 09-18-2013, 06:34 AM
  5. Replies: 0
    Last Post: 07-18-2012, 03:57 AM
  6. Replies: 3
    Last Post: 07-16-2012, 03:24 AM
  7. Disabling Printing ability of a sheet unless printing from a macro
    By cadamhill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-05-2012, 04:41 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