PDA

View Full Version : Solved: extract row from multi row range



dgs2001
04-18-2013, 02:42 AM
Hi

I know
Set v2 = Application.Index(r2, , 19)

will extract a column (19) from a multi column range, but I cant seem to get the right syntax for doing this with a row.

Please help Thanks

p45cal
04-18-2013, 03:12 AM
Set v3 = Application.Index(r2, 3, 0)

dgs2001
04-19-2013, 01:50 AM
Thank You :friends: