cell shift

[khalil]

hi all
i have sheet 1 and sheet 2 in excel workbook,
when i shift any cell from any row to the right in sheet1 , i want cell E from the same row in sheet 2 to be shifted as well.

thanks
khalil

 

[ZVI]

...This is great, but the code below is working as great and it is working in my project the only thing, we need it to do as many undo steps...

Khalil, you reposted here my code from your another thread.
Please do not mix threads and continue posting your separate task in the separate thread already created by you.

For more than one step undo buffer try one of two possible directions :
1. Use array RngUndo(1 To 100) for 50 steps or even the dynamic range RngUndo().
2. Use collection for saving inserted ranges in its items. Collection items can be easy added/deleted directly.

At problem please post in your another thread your code attempt and describe where the problem is in it.

 

[khalil]

thank you Vladimir,
sorry it was a mistake posting in a different thread

thanks again

 

[ZVI]

thank you Vladimir,
sorry it was a mistake posting in a different thread

thanks again

It is ok, your another post has the same name therefore it’s good reason to mix it up
BTW, hope you know that the code you posted does not work correctly with freezing formats code

 

[khalil]

hi,
i am glad to till you it works fine with freezing format
but i am still trying to do the undo steps with the solution you just sent, but no luck so far

little help from you it might help

 

[ZVI]

...i am still trying to do the undo steps with the solution you just sent, but no luck so far

Khalil, ones again, please post undo task questions in the original (another) thread.
If you are on learning VBA please post your own code there, even one your own line with details about what exactly is not working to help with it.
Regards,