Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help - loop through cells in a range that are not together (several different cells as Target)
Hi,
I'm stuck. I need to loop through each cell with my code and get range error. I belive it is because the range consist of cells that are not together.Right? Actually, the event is when you copy one cell and select a number of others and paste - dadaam, all cells have the same value as the copied cell. I use Worksheet_change event and now I need to run some code with each cell in Target. How to do that? /Kind regards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help - loop through cells in a range that are not together (severa
Can't really tell what is going wrong without seeing your code. but here is a
way to loop through the target range cell by cell, even if the cells are non-adjacent: Dim K As Range MsgBox Target.Address ' shows the address that Target itself is set to For Each K In Target.Cells MsgBox K.Address ' shows that now K is one of the individual cells in Target Next K "Marie J-son" wrote: Hi, I'm stuck. I need to loop through each cell with my code and get range error. I belive it is because the range consist of cells that are not together.Right? Actually, the event is when you copy one cell and select a number of others and paste - dadaam, all cells have the same value as the copied cell. I use Worksheet_change event and now I need to run some code with each cell in Target. How to do that? /Kind regards |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help - loop through cells in a range that are not together (several different cells as Target)
for each cell in Target
Next -- Regards, Tom Ogilvy "Marie J-son" wrote in message ... Hi, I'm stuck. I need to loop through each cell with my code and get range error. I belive it is because the range consist of cells that are not together.Right? Actually, the event is when you copy one cell and select a number of others and paste - dadaam, all cells have the same value as the copied cell. I use Worksheet_change event and now I need to run some code with each cell in Target. How to do that? /Kind regards |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help - loop through cells in a range that are not together (severa
Thank you Dale,
/Regards "K Dales" skrev i meddelandet ... Can't really tell what is going wrong without seeing your code. but here is a way to loop through the target range cell by cell, even if the cells are non-adjacent: Dim K As Range MsgBox Target.Address ' shows the address that Target itself is set to For Each K In Target.Cells MsgBox K.Address ' shows that now K is one of the individual cells in Target Next K "Marie J-son" wrote: Hi, I'm stuck. I need to loop through each cell with my code and get range error. I belive it is because the range consist of cells that are not together.Right? Actually, the event is when you copy one cell and select a number of others and paste - dadaam, all cells have the same value as the copied cell. I use Worksheet_change event and now I need to run some code with each cell in Target. How to do that? /Kind regards |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help - loop through cells in a range that are not together (several different cells as Target)
Damn you, Tom. Why does it look so easy for you...-)
Working all right, of course Thanks you /Regards "Tom Ogilvy" skrev i meddelandet ... for each cell in Target Next -- Regards, Tom Ogilvy "Marie J-son" wrote in message ... Hi, I'm stuck. I need to loop through each cell with my code and get range error. I belive it is because the range consist of cells that are not together.Right? Actually, the event is when you copy one cell and select a number of others and paste - dadaam, all cells have the same value as the copied cell. I use Worksheet_change event and now I need to run some code with each cell in Target. How to do that? /Kind regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Several target cells in the solver | Excel Discussion (Misc queries) | |||
Maintaining a cells value once a target is achieved | Excel Worksheet Functions | |||
How do I loop a range of cells until I get a numeric value? | New Users to Excel | |||
Target Cells | Excel Worksheet Functions | |||
Defining Range of For Each Loop for Cells and Worksheets | Excel Programming |