Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying values not formulas
I have the following piece of code
Here.EntireRow.Copy Destination:=There This copies the formulas that are in this row, I need to know how to modify this code to copy values instead of formulas. Any help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying values not formulas
here = there
-- Regards, Tom Ogilvy "Joe M." wrote in message ... I have the following piece of code Here.EntireRow.Copy Destination:=There This copies the formulas that are in this row, I need to know how to modify this code to copy values instead of formulas. Any help? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying values not formulas
Hi Tom, that will work for individual cells but I was
hoping for something that will allow me to copy the values of an entire row at a time. -----Original Message----- here = there -- Regards, Tom Ogilvy "Joe M." wrote in message ... I have the following piece of code Here.EntireRow.Copy Destination:=There This copies the formulas that are in this row, I need to know how to modify this code to copy values instead of formulas. Any help? . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying values not formulas
It works for any contiuous range of cells (of the same shape / count)
Range(1:1).Value = Range("15:15").Value or Range("A1").Resize(range("15:15").Rows.count, _ range("15:15").Columns.count).Value = Range("15:15").Value if you want to use a paradigm similar to a single cell destination. -- Regards, Tom Ogilvy "Joe M." wrote in message ... Hi Tom, that will work for individual cells but I was hoping for something that will allow me to copy the values of an entire row at a time. -----Original Message----- here = there -- Regards, Tom Ogilvy "Joe M." wrote in message ... I have the following piece of code Here.EntireRow.Copy Destination:=There This copies the formulas that are in this row, I need to know how to modify this code to copy values instead of formulas. Any help? . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying values not formulas
typo:
Range(1:1).Value = Range("15:15").Value should be Range("1:1").Value = Range("15:15").Value or Range("A1").EntireRow.Value = Range("A15").EntireRow.Value -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... It works for any contiuous range of cells (of the same shape / count) Range(1:1).Value = Range("15:15").Value or Range("A1").Resize(range("15:15").Rows.count, _ range("15:15").Columns.count).Value = Range("15:15").Value if you want to use a paradigm similar to a single cell destination. -- Regards, Tom Ogilvy "Joe M." wrote in message ... Hi Tom, that will work for individual cells but I was hoping for something that will allow me to copy the values of an entire row at a time. -----Original Message----- here = there -- Regards, Tom Ogilvy "Joe M." wrote in message ... I have the following piece of code Here.EntireRow.Copy Destination:=There This copies the formulas that are in this row, I need to know how to modify this code to copy values instead of formulas. Any help? . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying values not formulas
Thanks Tom, that did the trick.
-----Original Message----- typo: Range(1:1).Value = Range("15:15").Value should be Range("1:1").Value = Range("15:15").Value or Range("A1").EntireRow.Value = Range("A15").EntireRow.Value -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... It works for any contiuous range of cells (of the same shape / count) Range(1:1).Value = Range("15:15").Value or Range("A1").Resize(range("15:15").Rows.count, _ range("15:15").Columns.count).Value = Range ("15:15").Value if you want to use a paradigm similar to a single cell destination. -- Regards, Tom Ogilvy "Joe M." wrote in message ... Hi Tom, that will work for individual cells but I was hoping for something that will allow me to copy the values of an entire row at a time. -----Original Message----- here = there -- Regards, Tom Ogilvy "Joe M." wrote in message ... I have the following piece of code Here.EntireRow.Copy Destination:=There This copies the formulas that are in this row, I need to know how to modify this code to copy values instead of formulas. Any help? . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying values/formulas from only visable lines when filters are o | Excel Worksheet Functions | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Drop and drag is copying values instead of formulas | Excel Worksheet Functions | |||
copying formulas and not values | Excel Worksheet Functions | |||
Why do formulas turn to values wen copying in Excel 2003... | Excel Worksheet Functions |