Macro to find a header based on a value in another cell

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Macro to find a header based on a value in another cell

07-01-2019, 03:31 AM

p45cal

Windows 10 Macro to find a header based on a value in another cell

Office 2016

Expert

Join Date: Apr 2014

Posts: 956

Code:

Sub blah()
Columns(Application.Match(Range("V1").Value2, Rows(2), 0)).Copy Columns("AG")
End Sub

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to select cell based on formula	mreynolds1775	Excel Programming	4	09-22-2017 12:13 PM
Macro- find and replace from preselected options based on frequency (like an Ad libs)	blondie	Word VBA	0	02-27-2017 01:41 PM
Can anyone here tweek this macro for renaming Excel files based on a cell's contents?	chrisd2000	Excel Programming	6	07-01-2014 01:53 PM
Word VBA Macro to Find and Replace based on the Alt Text of an Image	bennymc	Word VBA	1	01-27-2014 04:23 PM
Macro based on cell value	ubns	Excel Programming	1	05-07-2012 04:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:34 PM.