Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VBA Question / Clearing out All Data
I would like to clear all my data that is in cell C4:J30000.
Is there a way to do this with a vba macro ? Thank you in advance. |
#2
|
|||
|
|||
Sub test()
Range("C4:J30000").Clear End Sub HTH, Gary Brown "carl" wrote: I would like to clear all my data that is in cell C4:J30000. Is there a way to do this with a vba macro ? Thank you in advance. |
#3
|
|||
|
|||
thank you. that worked great for me.
is there a way to have only the data cleared out yet leave the formating unchanged ? regards. "carl" wrote: I would like to clear all my data that is in cell C4:J30000. Is there a way to do this with a vba macro ? Thank you in advance. |
#4
|
|||
|
|||
Change to...
Range("A1:A10").ClearContents HTH, Gary Brown "carl" wrote: thank you. that worked great for me. is there a way to have only the data cleared out yet leave the formating unchanged ? regards. "carl" wrote: I would like to clear all my data that is in cell C4:J30000. Is there a way to do this with a vba macro ? Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
Another question on how to find duplicate data | Excel Worksheet Functions | |||
Data Table Question | Charts and Charting in Excel |