Re: [ExcelVBA] Re: Clearing the cells that have no links to them.

 

Thanks,
I'll try it.

On Fri, Jun 3, 2011 at 6:49 PM, Pascal <pascaldaulton@lineone.net> wrote:

>
>
> I forgot to say that this macro keeps cells which have links to them from
> ANY sheet in the workbook, including the one you're processing.
>
>
> --- In ExcelVBA@yahoogroups.com, "Pascal" <pascaldaulton@...> wrote:
> >
> > The following macro (trial it on a copy of your workbook) will highlight
> two areas on the active sheet when run. Those cells which you say you want
> to keep (be careful and read what David Braithwaite said about deleting
> cells you may not really want to delete) will be highlighted by formatting
> with a diagonal line, and those that you want to keep with a light green
> fill.
> >
> > That way you don't lose your data you might want to keep.[snip]
>
>
>

--
Lipa Roitman

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (7)

Recent Activity:

• New Members 6

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___