+ Reply to Thread
Results 1 to 4 of 4

Excel Macro Save As Cell Value

  1. #1
    Registered User
    Join Date
    02-15-2012
    Location
    London, United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    69

    Thumbs up Excel Macro Save As Cell Value

    Hi,

    I'm struggling to get this work, basically i have a macro which copies data from each line, based on the row info copied.

    The current code i have is as follows:

    Sub Macro1()
    '
    ' Macro1 Macro
    ' Keyboard Shortcut: Ctrl+r
    Let x = 0
    Do While x < 190
    ActiveWindow.SmallScroll Down:=33
    Rows("61:190").Select
    Selection.Copy
    Rows("60:60").Select
    ActiveSheet.Paste
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
    IgnorePrintAreas:=False
    ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell

    x = x + 1
    Loop
    End Sub
    i want the file to save as cell "A9" data

    Thank you in advance.

    Kind Regards,

    Caf20012

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Excel Macro Save As Cell Value

    Maybe add to the bottom of your sub after the loop:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-15-2012
    Location
    London, United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    69

    Re: Excel Macro Save As Cell Value

    Hi John,

    Anyway for it to automatically save without prompting me each time to confirm?

    Kind regards,

    Caf20012

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Excel Macro Save As Cell Value

    Maybe:

    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. [SOLVED] Macro to automatically save an Excel with a specific name depending on cell value
    By Stefan1979 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-17-2013, 11:51 AM
  2. [SOLVED] Macro to save a Word Doc title based off a cell in Excel
    By vnakashi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2013, 01:24 PM
  3. Macro with cell reference as a name, but prompt for save location and save as csv
    By tomham in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2012, 06:21 PM
  4. Replies: 5
    Last Post: 09-13-2012, 09:49 AM
  5. How to save Excel macro using name contained in cell?
    By CG in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-03-2005, 12:06 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