How do I add a line using VBA in Excel 2013

[Jazzzbo]

I want to add a line after the last row of my worksheet. Using a macro, I came up with the following:

Please Login or Register  to view this content.

How can I get the line to run from my first column to my last column after the last row?

Thanks

Jim

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[HaHoBe]

Hi, Jium,

maybe like this:

Please Login or Register  to view this content.

The first 0 stands for the bgein of the line on the edge of the Application Windows at the left of Column A - you will have to change that if the data doesn´t start in Column A.

Ciao,
Holger

[Jazzzbo]

I couldn't get this to work, however the other response did. Thanks

[JOHN H. DAVIS]

Can't tell which post you are refering too, but if you have a solution please comply with Forum Rule no. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.