Hi everyone,
in excel i want to add a sheet after the last sheet using VBA, but i didn't manage to convert the following VBA code into VEE:
*Sheets.Add After:=Worksheets(Worksheets.Count)*
when i just use *Sheets.Add* it works, but this always add a sheet before the active sheet.
hope that someone can help me.
Thanks
in excel i want to add a sheet after the last sheet using VBA, but i didn't manage to convert the following VBA code into VEE:
*Sheets.Add After:=Worksheets(Worksheets.Count)*
when i just use *Sheets.Add* it works, but this always add a sheet before the active sheet.
hope that someone can help me.
Thanks
I tried a few things and can't seem to get this working. No one on the VRF can figure it out either. One thing you could do is make a function in C# that you call from VEE.
In the future you will get faster replies to your questions if you use the VEE Reflector (VRF) as follows:
To subscribe send an email to: "vrf-request@general.lists.agilent.com" with the word subscribe in the message body (no long signatures and plain text only).
To unsubscribe send a blank email to "leave-vrf@general.lists.agilent.com" (no long signatures and plain text only).
To send messages to this mailing list, email "vrf@general.lists.agilent.com".
-Bill