ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro code to dll and vba code trouble shoot. (https://www.excelbanter.com/excel-programming/411006-macro-code-dll-vba-code-trouble-shoot.html)

mario

Macro code to dll and vba code trouble shoot.
 
Question 1:
Can somebody correct this code:
Selection.AutoFill Destination:=Range(Cells(1, 4).Address, Cells(LastRow,
3).Address)

The above one gives a lot of errors.

Question 2:
I have a macro. I want to convert it to a dll so that other users can do
something like tools, add-in, browse to the dll and the macro is installed.

Is there a way to do the above.

If so will the shortcuts assigned be preserved during dll (or xll) conversion.


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com