Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy, then Paste "Value" to the same cell...
I have a column A1 to A100 where names appear in the cells based on a
formula that populates them from another worksheet matching them against account numbers using the lookup function. So, everything works well except the other worksheet can change over time and it can foul up the "lookup" function and post a wrong name, say where one has been deleted. So, at the end of my existing code, I want to copy cell A1 and paste it as a value back to itself and then repeat it for all of the cells. My thanks in advance for any suggestions here. Brad |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy, then Paste "Value" to the same cell...
Sub brad()
Set r = Range("A1:A100") For Each rr In r rr.Copy rr.PasteSpecial Paste:=xlPasteValues Next End Sub -- Gary''s Student - gsnu200728 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy, then Paste "Value" to the same cell...
with worksheets("sheet999").range("a1:A100")
.value = .value end with Is another way. Brad wrote: I have a column A1 to A100 where names appear in the cells based on a formula that populates them from another worksheet matching them against account numbers using the lookup function. So, everything works well except the other worksheet can change over time and it can foul up the "lookup" function and post a wrong name, say where one has been deleted. So, at the end of my existing code, I want to copy cell A1 and paste it as a value back to itself and then repeat it for all of the cells. My thanks in advance for any suggestions here. Brad -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a one button shortcut for "copy cell above & paste here" | Excel Worksheet Functions | |||
copy and paste the cell with formula ="1" | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |