Windows 10: 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

:)

 

Help with Excel VBA Problem?

Can someone help me code the following VBA problem:

"Assume you have a mailing list file. This file is currently the active workbook, and the active worksheet of this book has full name in coloumn starting in cell A1, with the last name last and everything in uppercase letters (such as STEPHEN E. LEE). Write a sub that counts the number of names in the list with last name LEE and then displays the count in a MsgBox. Not that there might be last names such as KLEE, which should not be counted."

Thanks!

 

VBA Code returns NAME? ERROR

Have you copied VBA code in a standard module?

 

VBA on windows phones and tablets

I want to use Powerpoint to prototype an app that I am building. As such I need to customize the PPT file with VBA to do things like have countdown timers, drop down lists, popups etc.

From my research it appears I need a Surface Pro tablet with full office. Anything else like RT won't do the job.

However, I can't determine if a Windows phone will support VBA.

Can anyone confirm if full VBA support is available for Windows phones and tablets? And if so which OS and model.

Thank you,