+ Reply to Thread
Results 1 to 3 of 3

VBA modification to refer to a cell on 1 worksheet to populate a range on another

  1. 06-23-2014, 09:50 PM #1
    gwd
    gwd is offline
    Registered User
    Join Date
    04-09-2014
    Location
    australia
    MS-Off Ver
    Excel 2003
    Posts
    6

    VBA modification to refer to a cell on 1 worksheet to populate a range on another

    I am working on a spreadsheet to track spending. I currently have the value for column A hard coded into the worksheet change macro.
    What I am wanting to do is to change the line .Value = "SFCC" to look at a cell (say A2 on sheet 1[the summary sheet] which would have a user code entered. The code below is an extract of the worksheet change macro
    Thanks 


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 06-24-2014, 02:34 AM #2
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 365 on Win11 (365 on Win11 (desktop), 365 on Win11 (notebook)
    Posts
    8,206

    Re: VBA modification to refer to a cell on 1 worksheet to populate a range on another

    Hi, gwd,

    maybe
    Please Login or Register  to view this content.
    where you should adapt the name Summary to the tab name shown for the sheet or
    Please Login or Register  to view this content.
    where you should adapt the codename shown in the VBE for the sheet to hold the summary.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you
    Reply With QuoteRegister To Reply
  3. 06-24-2014, 04:05 AM #3
    gwd
    gwd is offline
    Registered User
    Join Date
    04-09-2014
    Location
    australia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: VBA modification to refer to a cell on 1 worksheet to populate a range on another

    Thanks Holger, I have danced around the formats you have provided without hitting on the actual syntax for some time before posting this morning.
    Thank you so much
    David
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. prevent cell values modification after saving the worksheet.
    By bittu2010 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-09-2012, 03:12 AM
  2. A formula to populate one cell based on the cell range on another worksheet
    By Squint in forum Excel General
    Replies: 2
    Last Post: 01-26-2011, 05:56 PM
  3. How to refer code to specific range in worksheet
    By gulaina in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2010, 04:16 AM
  4. Named Range : refer to Current WorkSheet
    By plitv001 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-01-2008, 07:13 PM
  5. Is there anyway to refer a range in other Worksheet without opening it???
    By d61helix in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-18-2005, 04:25 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1