ExcelBanter - vba: How do I write a "For Each Statement" nested in a "With Statement"?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - vba: How do I write a "For Each Statement" nested in a "With Statement"? (https://www.excelbanter.com/excel-programming/316088-vba-how-do-i-write-each-statement-nested-statement.html)

Mcasteel[_29_]

vba: How do I write a "For Each Statement" nested in a "With Statement"?

Im getting the error: *"For Each control variable must be variant o
object."

--
Mcastee
-----------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...fo&userid=1569
View this thread: http://www.excelforum.com/showthread.php?threadid=27639

All times are GMT +1. The time now is 05:23 PM.