VBA Copy Offset


  1. donnylad
    Posts : 174
    microsoft windows 10
       New #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
    Quote Quote

  3. donnylad
    Posts : 174
    microsoft windows 10
    Thread Starter
       New #2

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

  4. donnylad
    Posts : 174
    microsoft windows 10
    Thread Starter
       New #3

    Thankyou very much for that.
    Len
      My Computer
    Quote Quote

 

  Related Discussions
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...
Hello, I have two computers running Windows 10. One is a Toshiba C855 running the Home version, and the other is a Dell M6700 Covet running the Pro version. On both of these computers, I'm having an esthetic problem. Any windows which are not...
Ok, so, here's the whole story. I did a new clean install of windows 10 pro a few weeks ago, and I installed the newest version at the time, 1809 build 17763.316. However, now there is a newer version, 17763.348. And I've been getting the update...
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...
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 20:21.
Find Us




Windows 10 Forums