Results 1 to 15 of 15

Thread: Copy and Paste Error between Application instances

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #5
    VBAX Master
    Joined
    Jul 2006
    Location
    Belgium
    Posts
    1,285
    Location
    Does
    option compare text
    counts for worksheetnames ? It's because I tried the following :
    Sub test()
    Dim curMonth As String
    curMonth = MonthName(Month(Now()), False)
    End Sub
    The current month is december and not December. Could be nothing (edited : it's nothing, don't bother - just tested it) but it's because you hardcoded it in your manual copy routine ?

    Charlize
    Last edited by Aussiebear; 04-16-2023 at 03:22 PM. Reason: Adjusted the code tags

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •