Results 1 to 3 of 3

Quick Help w Macro

Threaded View

  1. #1
    Registered User
    Join Date
    04-10-2017
    Location
    california
    MS-Off Ver
    2017
    Posts
    27

    Lightbulb Quick Help w Macro

    Hi all, I have the following macro in place - it's giving me the subscript out of range error when I run it. is there something wrong with this (recorded) code?



    Thanks for any help in advance!


    Sub photo()
    '
    ' photo Macro
    '
    
    '
        ActiveWindow.ActivateNext
        ActiveWindow.ActivateNext
        Cells.Select
        Selection.Copy
        ActiveWindow.ActivateNext
        ActiveWindow.ActivateNext
        Sheets("Photo Documentation").Select
        Cells.Select
        ActiveSheet.Paste
        Range("E71").Select
        ActiveWindow.SmallScroll Down:=3
    End Sub
    Last edited by alansidman; 06-27-2017 at 03:16 PM. Reason: code tags added

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Quick help with a Macro Error
    By B_Jarbs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-05-2016, 01:06 PM
  2. Help creating quick macro - thanks!
    By skipper24 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-06-2015, 07:26 PM
  3. quick sort macro
    By LMHmedchem in forum Excel General
    Replies: 9
    Last Post: 03-26-2014, 05:26 PM
  4. [SOLVED] Quick question about automatic row deletion (should be very quick and easy!!)
    By poptart141 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-09-2013, 12:56 PM
  5. Need Quick Macro Help!
    By bxc2739 in forum Excel General
    Replies: 2
    Last Post: 04-24-2006, 03:32 PM
  6. Quick question - quick answer about assigning shortcut keys
    By funkymonkUK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2005, 06:05 AM
  7. quick lil macro
    By ChasePenelli in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2005, 08:05 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