+ Reply to Thread
Results 1 to 3 of 3

Help Change VBA code to Be range Specific

  1. 05-21-2014, 07:51 AM #1
    jmreddin
    jmreddin is offline
    Registered User
    Join Date
    05-21-2014
    Posts
    6

    Post Help Change VBA code to Be range Specific

    Hi All,

    I have found the below code which serves my purpose, But I would like it to only work within the Range C4:K40 within my worksheet.

    (The code inserts the Date (static) when the cell is clicked...)

    Please Login or Register  to view this content.
    Thanks in Advance!
    Last edited by Fotis1991; 05-21-2014 at 07:57 AM. Reason: pls use code tags around your codes
    Reply With QuoteRegister To Reply
  2. 05-21-2014, 07:58 AM #2
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Help Change VBA code to Be range Specific

    Add this above the existing If.
    Please Login or Register  to view this content.
    PS Can you add code tags when posting code?
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  3. 05-21-2014, 08:38 AM #3
    jmreddin
    jmreddin is offline
    Registered User
    Join Date
    05-21-2014
    Posts
    6

    Re: Help Change VBA code to Be range Specific

    Thanks Norie!

    (P.S Sorry, will use Code tags from Now on!)
    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. [SOLVED] code to automatically change value of a cell from a number to a specific word
    By excel151515 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2014, 02:47 PM
  2. Trying to create VBA code to change the scale of the x value on a specific graph
    By poindexter1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2013, 06:45 AM
  3. [SOLVED] Change the color of a row in a specific range
    By arkadd61 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-17-2013, 07:00 PM
  4. Code to open workbook and change value in a specific cell
    By rhudgins in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-01-2010, 05:27 PM
  5. Macro code to change cell range to named range
    By Orlic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2008, 11:51 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1