delete all the ranges that related to spesific sheet via macro

  • Thread starter Thread starter Miri
  • Start date Start date
M

Miri

i need to delete all the ranges that related to spesific sheet. how should i
do that?
i also need to copy all the ranges that related to spesific sheet to
another. how do i do that?

record it via macro didnt help me to find the solution... please advice
 
Hi Miri,

It is usually much easier for people to help when we have your initial
attempt to work from.
Can you please post your recorded code?

Rob

__________________
Rob Brockett
NZ
Always learning & the best way to learn is to experience...
 
and keep to the original thread, it gets confusing otherwise.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

delete Ranges via macro 1
replace all the cells in sheet that include spsific string-via mac 1
Creating a macro that writes to all worksheets 4
Error Message - Macro to Unlink MS Queries from Workbook 0
getting data from all files from a folder. 4
Creating a macro to open as save other selected Excel sheets 1
code for sorting data 6
clear all sheets code 4

Back
Top