Home Excel Powerpoint Word Outlook Error Codes

VBA Useful Codes

Welcome to the World of VBA
Home > VBAUsefulCodes

Match Lookup


Find Column Number using Column Name using Match function in VBA


match_lookup = Thisworkbook.Sheets("Sheet1").Range("1:1")
Application.WorksheetFunction.Match("columnname", match_lookup, 0)

Subscribe

Enter your e-mail below and get notified on the latest blog posts.




Tags

VBA Outlook KPI Excel Alt+F11 Dashboards Macros Recording Graphs Automation Developer WaterFall Powerpoint Charts Pivot Tables Forecast Charts


Follow Us