+ Reply to Thread
Results 1 to 4 of 4

Referencing specific cell within a page code

  1. #1
    Registered User
    Join Date
    12-22-2019
    Location
    British Columbia
    MS-Off Ver
    Office 2019
    Posts
    8

    Referencing specific cell within a page code

    Greetings,

    I have created/adjusted a page code that works great except for one thing! I need a single part of the coding to reference a cell in a sheet within the workbook!

    Here is what I have, and I need/would like to have the highlighted item actually reference a sheet called "References" and the cell referenced "L5"

    I hope that I've given enough information??

    Thanks
    ______________________________________________________

    Please Login or Register  to view this content.
    Last edited by Pepe Le Mokko; 12-24-2019 at 03:47 AM. Reason: Added tags plesae read rules

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    Re: Referencing specific cell within a page code

    like so

    Please Login or Register  to view this content.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,444

    Re: Referencing specific cell within a page code

    @steve

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    I did it for you this time. Please read forum rules. Thanks

  4. #4
    Registered User
    Join Date
    12-22-2019
    Location
    British Columbia
    MS-Off Ver
    Office 2019
    Posts
    8

    Re: Referencing specific cell within a page code

    Good morning.... all new to this, so I will definitely try to keep with the rules on the forum. Didn't even realize I was doing something incorrectly!

    Cheers!

+ 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. Syntax for code referencing a specific cell from a textbox
    By Toddiman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-31-2015, 11:45 AM
  2. Replies: 0
    Last Post: 09-02-2014, 12:59 PM
  3. Replies: 2
    Last Post: 08-02-2013, 08:04 AM
  4. Import specific column from web page in excel using vba code.
    By eyeshield21 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2013, 09:25 PM
  5. Code to print specific page
    By lee4clp in forum Excel General
    Replies: 2
    Last Post: 08-07-2010, 04:09 PM
  6. Excel 2007 : Referencing a cell on another page
    By the_ghost in forum Excel General
    Replies: 3
    Last Post: 08-07-2009, 10:51 AM
  7. Referencing a specific cell after found using VB code
    By phaley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2008, 07:07 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