delete Ranges via macro

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

Miri

hi
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?

i found the way to delete it according to the name.... it is not good enough
for my needs...
ActiveWorkbook.Names("vvv").Delete
 
Turn on the macro recorder and do it manually. Review the recorded code to
see how it is possible.
 

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 all the ranges that related to spesific sheet via macro 2
replace all the cells in sheet that include spsific string-via mac 1
Cell is locked but still editable... 2
Delete Named rnage and Add Named Range 5
Delete named ranges in VBA - by scope? 2
VBA set thick borders around non empty cells in range 0
Loop Repeats - PLS HELP 2
code for sorting data 6

Back
Top