Max function for all columns

[Dhelp]

Hi I'm trying to find the max value for each column with this code, but it stops after a blank row. I want the code to find the max of the entire column even if there are blank rows in the data. Any idea how to fix this code? Or is there a better way to write the code? Thanks!

'Outputting max value for each column

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[Dhelp]

Sorry! Thank you - I'll remember to do this for my next posts.

[Dhelp]

Hi Alan, should I re-post this in order to try to get a response?

[protonLeah]

If you are trying to replace the values in each cell of row one with the max of column then try:

Please Login or Register  to view this content.

EDIT: Does each column have the same number of rows?

[Dhelp]

Hi protonLeah, no the columns may not have the same number of rows. Also, I'm not trying to replace the values in the first row. The first row could be blank, but I still want it to output the max value for every column that has data. Does this make sense?

Thank you!

[protonLeah]

Your original code puts a formula in row 1 then copies and paste special back to row 1? (tested). So where should the max be written?

[Dhelp]

Sorry for the confusion! I just wrote code that works for what I need

Please Login or Register  to view this content.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.