+ Reply to Thread
Results 1 to 7 of 7

save to desktop macro

Hybrid View

  1. 11-20-2008, 04:06 PM #1
    asabti
    asabti is offline
    Registered User
    Join Date
    11-07-2008
    Location
    PA
    Posts
    33
    when i press F8 to see where the error is.. it highlights this:

    With Worksheets("Sheet8")
    what is wrong herE?
    Last edited by VBA Noob; 11-20-2008 at 04:14 PM. Reason: Added code tags as per forum rules
    Reply With QuoteRegister To Reply
  2. 11-20-2008, 04:21 PM #2
    Kenneth Hobson
    Kenneth Hobson is offline
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573
    Maybe a subscript error? This will happen if you don't have a sheet named "Sheet8".

    ActiveSheet should work ok if that is the sheet that you want to check.
    Reply With QuoteRegister To Reply
  3. 11-20-2008, 04:30 PM #3
    asabti
    asabti is offline
    Registered User
    Join Date
    11-07-2008
    Location
    PA
    Posts
    33
    amazing! thank you for all your help!!! WOW thanks!
    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)

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