1004 Application-defined or object-defined error using Border(X).linestyle

Hello Leeds55,

Your code:

.Selection.Borders(xlDiagonalDown).LineStyle = xlNone

Correction:

.Selection.Borders(xlDiagonalDown).LineStyle = xlLineStyleNone

You used the wrong constant name. Easy to do.

Regards,
Leith Ross

Mornin' Leith

Originally Posted by Leith Ross

Correction:

.Selection.Borders(xlDiagonalDown).LineStyle = xlLineStyleNone

You used the wrong constant name. Easy to do.

Thanks for the correction, but I'm afraid I'm still getting exactly the same error on exactly the same line.

Any other thoughts you could suggest?

Just for the record, VB tells me it's 6.3, Access 2003 & Excel 2003. I was hoping the tooltip on the constant name might alert me if I was using it wrong, but before & after your suggestion, the tooltip read <constantname>=Empty

Hi Leeds55,

Wow. Open the VBA editor and use the object browser to search all libraries for the constant. If it doen't find it then either something is corrupt or there is a undocmented feature (i.e. bug) we don't about.

BEst,
Leith

I found the constant (in Excel only, though you'd think that'd do it) as xlLineStyleNone, so I'm pretty much foxed. The only thought I have is that I might have had to do a slightly different "With" first: I think I was only in an Excel.Application, and I wonder whether the worksheet would have been better.

Anyway, my workaround was to take an empty cell from somewhere else in the spreadsheet & paste it into the range I didn't want borders for. Yes, that's a real kludge.

Where I did want borders, I used

Please Login or Register  to view this content.

For each cell that needed them. Possibly not a scalable solution, but it worked in this instance, actually leaving me with less code than I had before.

So, pretty happy. Thanks for the suggestion, Leith - at the very least it gave me another search term that led me to a solution!