Thursday, February 20, 2020

How to get current workbook worksheet name using vba

 Please paste these lines in VBA macro.

Dim DestWS As String
Dim DestWB As String

DestWB = ThisWorkbook.Name
DestWS = ActiveSheet.Name
Posted by at

1 comment:

  1. robertApril 14, 2020 at 2:56 AM

    GOOGLE MAPS MARKETING Simple Guideline for 2020. You need Google My Business, Google Maps Marketing how to get started Maps Marketing business increase...GOOGLE MAPS MARKETING

    ReplyDelete

Subscribe to: Post Comments (Atom)