+ Reply to Thread
Results 1 to 1 of 1

# use dictionary to save address and run it #

  1. #1
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,263

    # use dictionary to save address and run it #

    In Events worksheet change
    Example
    Input data in A1(count=1) then d1 select.. If input in d1 then g1 select ...etc.. every after select then interior. Color = target. Row
    But i want use dictionary for save target address. I want dict. item(target) =target.Offset(,3).address ,after save address in dictionary
    Then i calculate range(.keys). Select
    Its posibel to do
    Last edited by daboho; 02-06-2017 at 11:24 AM.

+ 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] Dictionary or Scripting.Dictionary. Binding Referencing Dim-ing. Sub routines and Function
    By Doc.AElstein in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 07-12-2016, 08:28 AM
  2. Storing a Dictionary into a Dictionary Object
    By pago_boss in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2015, 03:04 AM
  3. Scripting.Dictionary (Save to file and attach to workbook)
    By Kalithro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2015, 04:06 PM
  4. Dictionary - Using a dictionary of dictionaries to hold individual orders
    By wazimu13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2015, 08:32 PM
  5. outlook vba to prompt user to save email to hard drive if sent to a particular address
    By ohexcel_ineedu in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 02-19-2014, 10:49 PM
  6. [SOLVED] Save XL to PDF on desktop with cell address
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-25-2013, 08:24 AM
  7. [SOLVED] Issue with VBA - Save as macro enabled workbook - address problem.
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-09-2012, 08:14 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