Ryanchris
01-13-2020, 08:04 PM
Hello all!
I have some data on a sheet called "NewParts" and often need to delete the range N1:N24.
Using something like Range("N4:N24").ClearContents, clears everything in those cells including the formula that I have in those cells. Any ideas on how to clear just the numbers in those cells?
Thank you so much in advance for your help!!
I have some data on a sheet called "NewParts" and often need to delete the range N1:N24.
Using something like Range("N4:N24").ClearContents, clears everything in those cells including the formula that I have in those cells. Any ideas on how to clear just the numbers in those cells?
Thank you so much in advance for your help!!