Use of Range and Last row to add borders around cells.

**BBoydAnchor** · 05-18-2012, 04:34 PM

After searching and reading some other posts similar to what I'm looking to do, I have decided that I could use a little help.

The code I have right now that does not work is...

Please Login or Register  to view this content.

What I'm doing to taking a report that is supply in a Word Document and analyzing it in Excel. The macro I have created removes columns that are not needed and inserts a few new ones. The sheet has columns from A:H and I would like to have borders around all cells both empty and with content. However, every time I need to do this the row count will change. I feel that I'm on the right track, but not sure what corrections I need to make for it to work.

BTW... there is no hurry on this as I'm leaving the office soon and will not return until Monday.

Thanks in advance.

Brian

**Alf** · 05-19-2012, 03:12 AM

I tested you code snippet and it works fine.

What kind of problem do you have with it? Do you get any error messages? Or do you want to get rid of "old" borders before you write new data to range A1:H & LastRow.

If this is the case you could just add

Please Login or Register  to view this content.

to get rid of "old" borders.

Alf

**BBoydAnchor** · 05-21-2012, 12:14 PM

I get a run-time error '1004': Method 'Range' of object '_Global' failed. Below is all the code. It was created as one would normally do by recording the steps and then I modified the code the best I knew how. There may even be some code that could be removed or modified to be more efficient.

Please Login or Register  to view this content.

**Alf** · 05-21-2012, 01:52 PM

You could try to change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and also change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Alf

**BBoydAnchor** · 05-21-2012, 03:05 PM

Thank you Alf. This works perfectly.

**Alf** · 05-22-2012, 01:38 AM

Glad to be of help.

Alf

Use of Range and Last row to add borders around cells.

LinkBack

Thread Tools

Rate This Thread

Display

Use of Range and Last row to add borders around cells.

Re: Use of Range and Last row to add borders around cells.

Re: Use of Range and Last row to add borders around cells.

Re: Use of Range and Last row to add borders around cells.

Re: Use of Range and Last row to add borders around cells.

Re: Use of Range and Last row to add borders around cells.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions