-
You might get some help from the solutions here:
Excel-vba Application.Run alternative to run macro with named arguments - Stack Overflow
https://stackoverflow.com/questions/...amed-arguments
Also, since it looks as though you might be passing an object (ws a sheet?) there might be something of interest here:
Application.Run and ByRef Arguments
http://tushar-mehta.com/publish_trai...n_method.shtml
While searching I came across:
https://www.ozgrid.com/forum/index.p...e-excel-cells/
which is a cross post (that's fine) but not fine without supplying links to crossposts, see this:
Excelguru Help Site - A message to forum cross posters
https://www.excelguru.ca/content.php?184
for netiquette (many forums have it as a requirement, not just netiquette)
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules