Draw lines between cells

**Len Silva** · 02-20-2018, 09:40 PM

Thanks to the help I received on another post, I got the conditional formatting to work on this sheet. Now I am trying to figure out how to draw lines between highlighted cells as I did manually in the attached sample. I found some VBA online but it was beyond my comprehension and I could not figure out how to identify the highlighted cells. I will be doing a lot of these, some as much as 60 columns wide.
Thanks for all you guys do.

**yujin** · 02-20-2018, 11:51 PM

Maybe I don't figure out exactly what you want, but try this one.

Please Login or Register  to view this content.

**Andy Pope** · 02-21-2018, 04:38 AM

try this

Please Login or Register  to view this content.

**yujin** · 02-21-2018, 06:53 AM

Sorry, I've realized I'd misunderstood Len's post.
Forget about my code. Andy's solution will be correct.

**Len Silva** · 02-21-2018, 10:53 AM

Thanks Andy.
I get run-time error '438':
Object doesn't support this property or method.

The debugger highlights:
If data.Cells(rowIndex, colIndex).DisplayFormat.Interior.Color = data.Cells(rowIndex, colIndex).FormatConditions(1).Interior.Color Then

Am I supposed to install the function and the sub in the same module?

Thanks

**Andy Pope** · 02-21-2018, 11:21 AM

I would guess the DisplayFormat is not available in excel 2007.

You would need code to determine whether the conditional formating has been applied to any of the cells. The basically means applying the same CF test in the vba code.

**shg** · 02-21-2018, 11:43 AM

Originally Posted by Andy Pope

I would guess the DisplayFormat is not available in excel 2007.

Indeed; introduced in Excel 2010.

Nice to have you stop by, Andy -- we don't see enough of you.

**xladept** · 02-21-2018, 01:11 PM

Another that won't work in 2007

Please Login or Register  to view this content.

**Len Silva** · 02-21-2018, 04:26 PM

Thanks all!
I never really had a reason to upgrade until now, but this is an important project to me. Hello, Microsoft?

Here is the CF code I am using. Can anyone help me incorporate it into the script?

Please Login or Register  to view this content.

Draw lines between cells

LinkBack

Thread Tools

Rate This Thread

Display

Draw lines between cells

Re: Draw lines between cells

Re: Draw lines between cells

Re: Draw lines between cells

Re: Draw lines between cells

Re: Draw lines between cells

Re: Draw lines between cells

Re: Draw lines between cells

Re: Draw lines between cells

Thread Information

Users Browsing this Thread

Similar Threads

Draw 3 points with 2 limit lines on a graph

Draw lines across an autofiltered range of cells, but not across the filtered out cells

Formula to draw known didtance between parallel lines.

Draw lines in a chart

Can you draw lines through the center of cells, using cell numbers as references?

[SOLVED] VBA draw and erase lines (crosshairs) on form

[SOLVED] Excel VBA - How to draw lines & boxes on a Form ?

Bookmarks

Bookmarks

Posting Permissions