How to select and delete a range of cells between two different ranges of unequal size?

Hello,

I need to be able to select all the cells in between all the $$ (Range B3:G6). The goal is to delete them leaving any columns to the right/left or rows above/below alone.

I am currently using a "union" to select all the $$ but the range inbetween them is not selected. The range between the $$ is dynamic from one worksheet to another.

Any help would be great.

Here is an example of the table:

#	AAA	BBB	CCC	DDD	EEE	FFF	AAA	BBB	CCC
Time	A	B	C	D	E	F	A	B	C
0	$$	$$	$$	$$	$$	$$	27	64	88
0.1	7	7	18.12	0.1503	29.83	42	503	879.2	200
0.2	7	7	18.12	0.1503	29.83	42	503	879.2	200
0.3	$$	7	18.12	0.1503	29.83	42	503	879.2	200

Please Login or Register  to view this content.

Not sure if this helps but try using the intersect function to test if a cell is within a range.

Please Login or Register  to view this content.

Hello GaidenFocus,

Range1 is dynamic from worksheet to worksheet and the ranges will never intersect. My issue is selecting the range in between.

Thanks for the suggestion though

You could make the whole thing your range, and if it intersects your dynamic range, delete, or don't delete based on what that range is.

Mikerickson,

Thanks for the great idea! Works perfect!

See below for the fix.

Please Login or Register  to view this content.