#vba

Jun 11 min read

The Most Powerful VBA Tricks: UDF Secrets

User-Defined Functions (UDFs) in VBA (Visual Basic for Applications) are custom functions that you can create to perform calculations or...

2 views0 comments

May 251 min read

Click for a Chart in Excel using VBA.

Do you wish to have a tutorial for this? Please comment below. #vba #excelvba #excelcharts #exceltipsandtricks

4 views0 comments

May 1, 20231 min read

𝑯𝒐𝒘 𝒕𝒐 𝒈𝒆𝒕 𝒂 𝑫𝒓𝒊𝒍𝒍 𝑫𝒐𝒘𝒏 𝑬𝒙𝒑𝒆𝒓𝒊𝒆𝒏𝒄𝒆 𝒊𝒏 𝑬𝒙𝒄𝒆𝒍 𝑪𝒉𝒂𝒓𝒕𝒔 |

𝑯𝒐𝒘 𝒕𝒐 𝒈𝒆𝒕 𝒂 𝑫𝒓𝒊𝒍𝒍 𝑫𝒐𝒘𝒏 𝑬𝒙𝒑𝒆𝒓𝒊𝒆𝒏𝒄𝒆 𝒊𝒏 𝑬𝒙𝒄𝒆𝒍 𝑪𝒉𝒂𝒓𝒕𝒔 || 𝐒𝐭𝐨𝐫𝐲 𝐓𝐞𝐥𝐥𝐢𝐧𝐠 𝐰𝐢𝐭𝐡...

9 views0 comments

Oct 10, 20201 min read

Pivot Tables with VBA - New Video Series

New #VBA #Series is Coming up! Please be the #member of www.perepaedu.com and Subscribe to www.youtube.com/perepavijay Keep watching for...

36 views0 comments

Aug 14, 20201 min read

Hide or Un-hide sheets based on selection using VBA in Excel: A Most common question Asked in in VBA

This is a most common question asked across the Groups. How to Hide or Un-hide Sheets based on Selection. There are two ways One, by...

37 views0 comments