Retrieving Current Row,Columns & copying Format from Row,Columns a

C

Chris Maddogz

Currently I manually insert a new line of data into a worksheet from an
external source then using a macro I reformat the fill,font & alignment of
the row.

Within the inserted row at columns H & I - I want to copy the format of the
of the inserted row minus one's columns H & I (ie highlight current Row
-1(H:I) and paste special the format into inserted row (H:I)

Thank You
 
K

KC

May be

rownr = ActiveCell.Row
Cells(rownr - 1, "H").Resize(, 2).Copy
Cells(rownr, "H").Resize(, 2).PasteSpecial xlPasteFormats
 
C

Chris Maddogz

Worked fine Thanks You

KC said:
May be

rownr = ActiveCell.Row
Cells(rownr - 1, "H").Resize(, 2).Copy
Cells(rownr, "H").Resize(, 2).PasteSpecial xlPasteFormats
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Import multiple workbooks to current workbook in specified row number 0
Need help copying certain cells from current row 2
VBA - retrieve data on last create named range from previous inserted named range 0
VBA - Copying a Certain Colored Row to Paste in Another Worksheet 1
Insert Row & Paste Data 2
clearcontents for some columns of a row 3
Text To Columns then insert rows 9

Top