VBA Copy Offset Solved

  1.    #1

    VBA Copy Offset


    Hi all,, what I am trying here is to copy a range and offset it to the contents of the cell in AH5 but I am geting the Mismatch error, Can you tell me where I am going wrong Please.
    Range("Ad10:AG17").Copy Range("AH10").Offset(, "AH5")
    Len
      My ComputerSystem Spec

  2.    #2

    Done it ,, how good am I ??.
    Range("Ad10:ag17").Copy Range("AH10").Offset(, Range("AH5").Value)
    Len
      My ComputerSystem Spec

  3.    #3

    Thankyou very much for that.
    Len
      My ComputerSystem Spec


 

Related Threads
Windows Time Sync Offset in General Support
This a probably a different manifestation of the problem I reported in another thread ("Windows 10 Clock Running Slow"). I thought my PC Windows 10 clock was drifting behind, but during the last few days at least, that isn't the problem I'm...
2 Hours offset in OS clock. in General Support
Hi, Windows's clock is always offsetted of 2 hours back in time, but the time zone is correct (GMT +1). Auto time set is enabled, disabling / reenabling it doesn't do anything (it actually gets stuck reenabling it, but if i close and reopen the...
Today is April 24th 2018 and the UK is in British summertime which is UTC + 1 hour. Windows shows my offset as UTC + 0. I am in London (England) and my windows clock is showing the correct time but I have an application which needs to calculate UTC...
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 23:42.
Find Us