What do you want to save?
Add Code snippet
New code examples in category VBA
-
Jacob Erickson 2021-09-05 16:51:04
vba pass named range to function
Private Sub copyABU() Call copyPaste(ThisWorkbook.Names("myRange1").RefersToRange) Call copyPaste(ThisWorkbook.Names("myRange2").RefersToRange) Call copyPaste(ThisWorkbook.Names("myRange3").RefersToRange) ' //etc ... Add solution -
Pablo Descamisado 2021-09-05 13:50:02
Have formula hyperlink execute a VBA macro
'Execute VBA code from hyperlink on a worksheet that is the result 'of the HYPERLINK() worksheet function. 'Insert the following function in a standard code module: Function HyperlinkClick() Set HyperlinkClick = Selection 'Do whatever yo... Add solution -
Xawery Wiśniowiecki 2021-09-05 10:31:03
excel vba freeze panes without select
'VBA routine to freeze the Excel window panes. No selection required: Sub FreezePanes(row, col) With ActiveWindow If .FreezePanes Then .FreezePanes = 0 .SplitRow = row .SplitColumn = col If row + col Then .FreezePanes ... Add solution -
Skbeez 2021-09-04 12:45:02
excel vba wait
Application.Wait (Now + TimeValue("0:00:10")) Add solution