hard copy help

hail11

Board Regular
i am currently ussing this code

Dim a As Long
a = Worksheets("sheet1").Range("A" & Rows.Count).End(xlUp).Row
If a = 1 And Worksheets("sheet1").Range("A1") = "" Then x = 0
Worksheets("sheet1").Range("A" & a + 1) = Range("b6")

however i need to copy down the row from a1 till a44 and past it in on b1 till all the way to b44 ??

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

stanleydgromjr

Banned
hail11,

Try this:

Code:
``````    Dim a As Long
a = Worksheets("sheet1").Range("A" & Rows.Count).End(xlUp).Row
If a = 1 And Worksheets("sheet1").Range("A1") = "" Then x = 0
Worksheets("sheet1").Range("A" & a + 1) = Range("b6")

'however i need to copy down the row from a1 till a44 and past it in on b1 till all the way to b44 ??

Worksheets("sheet1").Range("A1:A44").Copy Worksheets("sheet1").Range("B1")``````

Have a great day,
Stan

hail11

Board Regular
i tryed this
Worksheets("sheet1").Range("A1:A44").Copy Worksheets("sheet1").Range("B1")

however i have code in these i just need that values that the codes have taken not the formulas. I used the code above to do single cells however i need to do more then that

hail11

Board Regular

Sheets("sheet1").Copy
Sheets("Sheet2").Paste

but i need it to copy the whole page and paste with all the actuals

Replies
9
Views
1K
Replies
9
Views
452
Replies
6
Views
294
Replies
4
Views
270
Replies
2
Views
193

1,190,627
Messages
5,982,011
Members
439,751
Latest member
megaman777

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back