+ Reply to Thread
Results 1 to 2 of 2

Range - Issue

  1. #1
    Registered User
    Join Date
    09-13-2008
    Location
    Home
    Posts
    6

    Range - Issue

    Hi,

    I need ur help to automate one MIS Report.

    Description: Daily we will circulate MIS by downloading the open items lying in GL. Total no of line items will vary on daily basis. I have created a macro where i have selected Range from first item to last one(5800 Line items). But on day 2 it would increase to 6500 as i have only selected range as 5800..system is showing an error. Instead of specific range selection can we fix some thing like 10000 Items ???? or System should automatically select the entire range based on the number of transactions.

    Please Login or Register  to view this content.

    Please suggest

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Range - Issue

    Please Login or Register  to view this content.
    If solved remember to mark Thread as solved

+ 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] Issue with Sorting a Range: Sort method of Range class failed
    By helpmeinexcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2013, 01:51 PM
  2. Range Sum issue
    By a2excel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-10-2012, 10:44 AM
  3. Replies: 0
    Last Post: 06-19-2012, 05:15 PM
  4. Issue copying multicell range to destination workbook range
    By kuraitori in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-24-2008, 02:48 PM
  5. [SOLVED] Range issue...
    By James in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-04-2005, 05:05 PM

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