Posts by Glombicki

MGMoreira,

I downloaded your add-in and it looks like something more than what I need. I am not sure I understand exactly how to use it.

If you refer to my post of Jan 28, this is the problem I am encountering. I have huge spreadsheets, greater than 10 MB, but a lot of the spreadsheet is waste. I want to know which cells I can delete by running a simple macro to tell me if the cell is dependent on anything.

How would I use your add in for that? Again, say cells B2, 4, 6, 8, 10 are dependents. And Cells B1, 3,5, 7, 9 are a combination of empty cells, numbers, and characters.

Thanks

I didn't mean to be caring a conversation exclusively with Ed here. If anyone else knows a macro/code that would do the trick please let me know.

Thanks

Ed,

Do you mind sharing some code that would work, b/c I am not getting it to work at all.

Let's just say you want a macro that would tell you (by highlighting the cell a color or by bolding it, etc.) all cells in B1:B10 that are dependents, ie used elsewhere in the worksheet.

Let's say cells 2, 4, 6, 8, and 10 are dependents so those cells should have some type of format change to them.

My problem is 2 fold: I either get an error message off the bat saying cell 1 is not dependent and my code stops or I only get cell 2 to be highlighted and it misses all my other cells (4,6,8, and 10 in my example).

If you would be so kind as to provide a code that I could copy and paste into VBA editor and than tweak that would be much appreciated.

Thanks

Ed,

I tried your code and it works ok if I have a dependent cell in B1. If however, I do not I get an error (debug) message.

I am trying to devise a macro that would identify cells that are dependents and am encountering great difficulty.

My problem is when I run my macro I get only the first dependent to be highlighted and nothing else in the range, even if it is a dependent, shows up as being dependent.

I have huge spreadsheets with a lot of information that can be cut out, so I think this macro would help identify some of my waste in these spreadsheets.

So if you have any suggestions or code to try please let me know.

Thanks