Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help on this strange event
Hi All
This is a snippet of code I use to move values from one sheet to another. Sheets("RunSheet P1").Select Columns("Y").Find("", Cells(Rows.Count, "Y"), xlValues, _ xlWhole, , xlNext).Select With Selection .Value = Sheets("Run Setup").Range("D2").Value End With Columns("CD").Find("", Cells(Rows.Count, "CD"), xlValues, _ xlWhole, , xlNext).Select With Selection .Value = Sheets("Run Setup").Range("A2").Value End With The frustrating thing is that when I run the code a 2nd time, it will insert the value in one of the cells, and not the other.. These Cells are not special, down & out blank cells with no formula, references, conditioning, zip. I even tried reverting back to copy/paste specialvalues, but it hung on the paste special. For some reason this: Columns("CD").Find("", Cells(Rows.Count, "CD"), xlValues, _ xlWhole, , xlNext).Select Doesn't like the Paste Special statement to follow it.... Any thoughts welcome. TIA Mick. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help on this strange event
And apologies for the multi-posting..
I forgot I created this one.... Scold....Ouch..... Disregard this thread.... Sorry.... Mick.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
apply cell change event to single column - WorksheetChange Event | Excel Programming | |||
Worksheet_Change Event Strange Behaviour | Excel Programming | |||
Need Help: Strange, Strange Behavior ( Not Me. My Model! ) | Excel Programming | |||
Click event on menu item is lost after first time firing of the event | Excel Programming | |||
How to trap delete row event and hide column event? | Excel Programming |