sometimes the usedrange.select returns an empty cell even though the data ended on the previous row. google results mentioned that there is some hidden formatting that is not easily detected.
i find that this happens when i run a macro that inputs values into cells and i subsequently delete the newly inputted data manually using the delete key
is there a vba code that will detect these hidden formatting and alert the user?
i find that this happens when i run a macro that inputs values into cells and i subsequently delete the newly inputted data manually using the delete key
is there a vba code that will detect these hidden formatting and alert the user?