VBA Copy Offset


  1. Posts : 163
    microsoft windows 10
       #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 Computer


  2. Posts : 163
    microsoft windows 10
    Thread Starter
       #2

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


  3. Posts : 163
    microsoft windows 10
    Thread Starter
       #3

    Thankyou very much for that.
    Len
      My Computer


 

Related Threads
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 18:03.
Find Us




Windows 10 Forums