Results 1 to 7 of 7

Revise current macro (SOLVED)

Threaded View

hazzaska Revise current macro (SOLVED) 12-10-2012, 07:19 PM
Sa DQ Re: Revise current macro 12-10-2012, 07:38 PM
Trebor76 Re: Revise current macro 12-10-2012, 07:42 PM
hazzaska Re: Revise current macro 12-10-2012, 08:27 PM
Trebor76 Re: Revise current macro 12-11-2012, 06:39 AM
hazzaska Re: Revise current macro 12-11-2012, 02:39 PM
Trebor76 Re: Revise current macro... 12-11-2012, 05:37 PM
  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    Stoke, England
    MS-Off Ver
    Ms 365
    Posts
    68

    Revise current macro (SOLVED)

    Hi All

    Can anyone tell me how to revise this macro to run based on a value entered into sheet "PasteDataHere" Cell T1? It currently works by the entry in red

    Thanks

    Sub Race()
    '
    ' Macro5 Macro
    '
    Application.ScreenUpdating = False
    'Let x = 0
    Do While x < 10
        Sheets("PasteDataHere").Select
        Range("A1:K49").Select
        Application.CutCopyMode = False
        Selection.Copy
        Sheets("Sheet3").Select
        Range("A11").Select
        Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
            xlNone, SkipBlanks:=False, Transpose:=False
        Sheets("PasteDataHere").Select
        Application.CutCopyMode = False
        Selection.Delete Shift:=xlUp
        Sheets("Sheet3").Select
        Range("M1").Select
        Call GreyCalc
        x = x + 1
    Loop
    End Sub
    Last edited by hazzaska; 12-11-2012 at 02:35 PM. Reason: SOLVED

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1