Consulting

Results 1 to 3 of 3

Thread: How to generate a dynamic range using VBA code

  1. 04-20-2016, 06:50 AM #1
    bbuk9999
    bbuk9999 is offline
    VBAX Regular
    Joined
    Sep 2015
    Posts
    48
    Location

    How to generate a dynamic range using VBA code

    Hi all,
    Does anyone know how to generate a dynamic range using VBA code and how to insert data in this dynamic range? . For example generating a dynamic with data in range Range("A1:D10") dynamically using VBA. Thanks anyone helps
    Last edited by Bob Phillips; 04-20-2016 at 08:25 AM. Reason: Disabled smilies
    Reply With Quote Reply With Quote
  2. 04-20-2016, 08:26 AM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    A1:D10 isn't dynamic! What determines what cells to include?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
  3. 04-20-2016, 08:50 AM #3
    bbuk9999
    bbuk9999 is offline
    VBAX Regular
    Joined
    Sep 2015
    Posts
    48
    Location
    Making a dynamic range based on the inserted data that I want.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules