Macro to copy the A1 cell and paste it in all the filtered column using special key type visible range option in macro

[Gopi_Krishna1 (Gopi Krishna)]

Macro to copy the A1 cell and paste it in all the filtered column using special key type visible range option in macro

[pravallikapaluri]

Hi @Gopi_Krishna1

Check this thread

How can I copy visible cells only and paste using vbscript?

Hi @robo_007 Use Invoke VBA activity from the Activities panel onto the design canvas. In the properties of the “Invoke VBA” activity, set the following values: CodeFilePath: Leave it blank to write the VBScript code directly in the “Code” property. Code: Enter the VBScript code to perform the copy and paste operations. Try to use this below VBScript code Dim excelApp, workbook, worksheet, range Set excelApp = CreateObject("Excel.Application") excelApp.Visible = False Set workbook = excelA…

[Parvathy (PS Parvathy)]

Hi @Gopi_Krishna1

Can you share sample Input?

Regards