+ Reply to Thread
Results 1 to 2 of 2

Variable for sheet name in vba ActiveCell.Formula

  1. #1
    Registered User
    Join Date
    02-08-2013
    Location
    Louisiana, USA
    MS-Off Ver
    Excel 2010
    Posts
    35

    Variable for sheet name in vba ActiveCell.Formula

    I am having trouble using a variable for a sheet name. Below is the line of code that is not working properly. I have declared the variable "cycle" as a string.

    This line of vba tries to open a new workbook
    Please Login or Register  to view this content.

    This line of vba works but will not be helpful as I need the code to go through about 122 worksheets.
    Please Login or Register  to view this content.
    Any help would be greatly appreciated.

  2. #2
    Registered User
    Join Date
    02-08-2013
    Location
    Louisiana, USA
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: Variable for sheet name in vba ActiveCell.Formula

    I had the syntax incorrect.

    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. Selecting a range of cells using ActiveCell where the start point is variable
    By jshaw82 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-12-2013, 05:54 AM
  2. Activecell offset with Variable
    By sgreni in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2011, 05:42 PM
  3. Countif with activecell.row variable for range?
    By JP Romano in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-24-2011, 11:45 AM
  4. Use ActiveCell from former sheet in formula
    By rubix in forum Excel General
    Replies: 3
    Last Post: 08-26-2010, 09:05 AM
  5. How to use ActiveCell Adress in variable?
    By Castor77 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-11-2010, 11:28 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