I'm trying to add a line at the top of a table and have the formulas included. The macro I'm using is not copying the formulas in column I and not copying the currency format in columns G, H and I . What do I need to add to make it work?
I'm trying to add a line at the top of a table and have the formulas included. The macro I'm using is not copying the formulas in column I and not copying the currency format in columns G, H and I . What do I need to add to make it work?
Try
Please Login or Register to view this content.
- Battle without fear gives no glory - Just try
It did not work; however, This is the first macro I have attempted so it might be operator error.
I double clicked the "new row button", removed the code I had already done, and cut/ pasted what you had. It did not work. What went wrong?
Here is the code I have so far. Is there something I can add to just have the formulas added?
Sheets("INVOICE ENTRY").Range("A27").Select
ActiveCell.EntireRow.Insert Shift:=xlDown
Sheets("INVOICE ENTRY").Range("b27:m27").Select
Selection.Borders.Weight = xlThin
Sheets("INVOICE ENTRY").Range("b27:m27").Select
Selection.Interior.ColorIndex = none
Here a remake using your code: see Sub InsertRow2()
In the first code is the constant HRow = 27 with the right value (header row ) ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks