Thread: [Solved] I use an array to traverse the monthly worksheet summaries in the workbook, why the display types do
View Single Post
 
Old 10-06-2020, 10:52 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
I'm not seeing a type mismatch on my machine so it probably depends on the contents of your worksheets.

Why aren't you using the previously supplied solution of using formulas on the bottom of your tables? See https://www.msofficeforums.com/excel...-each-row.html
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote