Results 1 to 13 of 13

Have error in Save macro - HELP!!

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-30-2015
    Location
    Northampton
    MS-Off Ver
    2010
    Posts
    275

    Have error in Save macro - HELP!!

    hi all,

    i have this Save macro which im using with data mapping

    Sub Cont_Save()
    With Sheet10
    If .Range("C6").Value = Empty Then
    MsgBox "Please enter todays date" 'This can be changed later
    Exit Sub
    End If
    ContRow = .Range("C99999").End(xlUp).Row + 1 'First Available Row
    For ContCol = 3 To 13 'Increase if adding new cols
    .Cells(ContRow, ContCol).Value = .Range(.Cells(11, ContCol).Value).Value 'Saves new contact in first empty row In database
    Next ContCol
    
    .Shapes("ExistContGrp").Visible = msoCTrue
        .Shapes("NewContGrp").Visible = msoFalse
        
    .Range("B7").Value = False 'Set New Contact to False
    
    End With
    End Sub
    and when ever i run the macro i get an error on the following line

    .Cells(ContRow, ContCol).Value = .Range(.Cells(11, ContCol).Value).Value
    the
    .Range(.Cells(11, ContCol).Value).Value
    is supposed to be when the cell row is supposed to start which in this case is row 11, which is correct.

    i just cant understand why, i was sure i did everything right....obviously not!!!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Error with Save As PDF macro in Mac but not in Windows
    By gazellette in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2016, 12:06 PM
  2. Error with VBA on and auto save macro
    By DZ217 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-08-2015, 02:49 PM
  3. [SOLVED] Run-time error 1004/Save file macro
    By egglee in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-04-2013, 06:22 AM
  4. Error with macro to save and send excel as pdf
    By Axildoofay in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2013, 05:23 AM
  5. [SOLVED] Run time error during workbook save in macro
    By t3623gl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2012, 10:19 AM
  6. Macro to save worksheet giving error
    By strder1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2012, 09:52 PM
  7. Save macro validation: if error got to cell a1?
    By 2funny4words in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-19-2009, 03:24 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