Results 1 to 6 of 6

Named ranges & error 1004 "cannot use that command on overlapping sections....

Threaded View

locolobo Named ranges & error 1004... 02-17-2022, 12:20 PM
AliGW Re: Few things? 02-17-2022, 12:33 PM
locolobo Re: Named ranges & error 1004... 02-17-2022, 01:40 PM
locolobo Re: Named ranges & error 1004... 02-22-2022, 10:47 AM
Richard Buttrey Re: Named ranges & error 1004... 02-22-2022, 10:51 AM
locolobo Re: Named ranges & error 1004... 02-25-2022, 07:21 AM
  1. #1
    Registered User
    Join Date
    02-03-2022
    Location
    Virginia
    MS-Off Ver
    365
    Posts
    8

    Named ranges & error 1004 "cannot use that command on overlapping sections....

    I'm just learning how to use VBA/Macros, and i have one macro referring to another macro. when the file is copied/renamed it tries to refer to the original file. I removed the file name from the macro and now steps through, but i get error 1004 "cannot use that command on overlapping sections....

    Could questions, how do i go about getting these macros consolidated? & How do i tell what is overlapping? I there's only one range & no merged cells.

    The PTSSheet2() - is to remove empty rows from copied worksheet
    The SimbadS()-is to copy/paste a hidden reference worksheet

    Sub PTSSheet2()
    '
    ' PTSSheet2 Macro
    '
    
    '
        Application.Run "SimbadS"
        Range("A3:G60").Select
        Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
        
    End Sub
    Sub SimbadS()
       Dim Ws As Worksheet
       
       Set Ws = Sheets("Pts template")
       Ws.Visible = xlSheetVisible
       Ws.Copy
       With ActiveSheet.UsedRange
          .Value = .Value
       End With
       Ws.Visible = xlSheetVeryHidden
       
            
    End Sub
    Last edited by AliGW; 02-17-2022 at 12:34 PM. Reason: Title changed - please think more carefully about your thread titles in future!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula if cell contains one of many things, and those "things" contain multiple "items"
    By JulianS96 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-28-2020, 07:08 AM
  2. Never to old to learn new things
    By DonEB in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-11-2019, 12:14 AM
  3. Cell Contains Many Things
    By mexcely in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-29-2019, 10:25 PM
  4. How can these things be done in Excel VBA?
    By quantum231 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-08-2019, 12:09 AM
  5. Hi all, hows things
    By gh256 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 05-24-2012, 09:40 AM
  6. Need help with many things :D
    By Swoosh983 in forum Excel General
    Replies: 14
    Last Post: 02-13-2007, 05:30 PM
  7. two things at once?
    By evanzo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2005, 09:15 AM

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