Copy Formula in range to new worksheet

[dveusa]

Hi,
I am new - with little VBA experience - to this and as a 70 year old man my brain is maybe a bit slower now than it used to be...
I am trying to copy a range in a worksheet to a new worksheet keeping the formula intact.
The code below (from this forum) copies only values, not formula.
Replacing Value with Formula does not work.

Please Login or Register  to view this content.

Also, I would like to keep the original formatting (column width, Style, etc.)

Last: I want to give the new file a name based on the contents of a cell. This cell contains a text formula combining the contents of 3 different cells.

Any help will be appreciated.

[venkat1926]

copy a range in a worksheet to a new worksheet

do not worry about your age. I am older to you.

now what is the need for adding, opening closing workbooks

take a new workbook
in sheet 1 type in A1 to C1

A1 1
B1 2
C1 =a1+B1
format c1 with color e.g. yellow (manually)

normally there is no need formacro

select C1 edit copy
goto sheet 2 select any cell edit-paste
the formula will be added to the cell in sheet 2

if you want a macro copying including the format

try this macro and see sheet2

Please Login or Register  to view this content.

[dveusa]

Thank you Venkat. Much appreciated.
problem solved