Running Ants.......

[Hjemmet]

I know the Running ants show up when Copying and Past…..


But is it Possible to get them to show with out doing the Cop/past function when a value is set en a Cell

Hjemmet

 

[Hjemmet]

Its Faster to send the file here

https://www.dropbox.com/s/z2lfbcdrz2z9qa7/Pulje med 16 Spillere Med Lodtrækning.xlsm?dl=0

its all the red Borders around cell

But This file is in Danish

 

[Hjemmet]

I have change the Info sheets to English so its better to Move Around the Project

https://www.dropbox.com/s/yoke9yqdn...Med Lodtrækning english Info sheets.xlsm?dl=0

 

[Rick Rothstein]

I know the Running ants show up when Copying and Past…..

But is it Possible to get them to show with out doing the Cop/past function when a value is set en a Cell

You can do the copy part by itself to put the marching ants around a cell or range of cells and as long as you don't turn the marching ants off (you don't need to paste the copied value to do so), they will remain marching even if your code or the user does other things on the worksheet (of course, this will affect the Undo buffer). For example, execute this line of code...

Range("C3:C5").Copy

when the selection is located anywhere else. You will get the marching ants until either the user turns them off by hitting the Esc key or when you or the user copies a different set of cells or your issues this command...

Application.CutCopyMode=False

 

[Hjemmet]

didn work proberly

it worksfine for the first cell but not cell's eksampel Range("C3:C5").copy an Rang ("C7:C8").copy

 

[Rick Rothstein]

didn work proberly

it worksfine for the first cell but not cell's eksampel Range("C3:C5").copy an Rang ("C7:C8").copy

When you have multiple replies, you should mention who your follow up message is directed to. It looks like you may be replying to me. The marching ants are what Excel places around cells being copied... Excel only allows a contiguous range (read that as rectangular) to be copied. As your two ranges constitute more than one rectangular range, you cannot put marching ants around both of them at the same time. So if that is your need, my suggestion will not work. And because the marching ants are built into Excel's copy functionality, I do not believe there will be any way to implement them, using any method, for non-contiguous ranges, so I think you will need to use a different method to highlight your cells.

 

[Hjemmet]

sorry if i reply too you but in first place you put the Range Function in Here
and that was the main reason how i ask you again

 

[Jaafar Tribak]

I have change the Info sheets to English so its better to Move Around the Project

https://www.dropbox.com/s/yoke9yqdn...Med Lodtrækning english Info sheets.xlsm?dl=0

I have taken a look at the workbook and I am afraid, it is rather involved plus it is in a laguage that I don't understand.

To keep things as simple as possible, I would take Rick's advice in post#13

 

[Hjemmet]

I try Rick's advice But ive think it end here Before it ran of the Track

Thanks for give it a try
Thanks a Lot everybody