+ Reply to Thread
Results 1 to 3 of 3

Referring to active sheet

  1. #1
    Registered User
    Join Date
    12-09-2013
    Location
    california
    MS-Off Ver
    Excel 2007
    Posts
    8

    Referring to active sheet

    Hi,
    I wonder how I can make this code:
    Range("solar!B1") = "hour 1"
    refer to the active sheet instead of the sheet "solar",
    and also, how can I make a sheet into the active sheet?

    Best,
    Jonas

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,626

    Re: Referring to active sheet

    Jonas

    Remove solar!.

    There are various ways you can make a sheet active.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Referring to active sheet

    Please Login or Register  to view this content.
    and
    Please Login or Register  to view this content.

+ 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. Replies: 4
    Last Post: 03-15-2013, 08:17 AM
  2. how can worksheet_activate event of active sheet work of active workbook
    By tahir mahmood in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2011, 08:19 AM
  3. Referring to Active Cell Selection
    By Toby.Leheup in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2011, 06:46 AM
  4. Date Formula on each sheet referring to previous sheet
    By simpson in forum Excel General
    Replies: 4
    Last Post: 04-19-2010, 04:48 PM
  5. Copy from active sheet and paste into new sheet using info from cell in active
    By Ingve in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2006, 06:00 PM

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