I have macros that I use to update the data rows in a worksheet, but I need to determine how many rows (if any) have been frozen by the Freeze Pane option, so that I can skip these rows in the data update process. Currently I am sending an Input Box asking the user for the number of heading rows when they run the macro, I'd like to be able to put in the number of frozen rows as the default to this input box.
Thanks