Hi all I am just out of surgery for my eyes so I cannot see all the best.
On the attached file I wish to move the data in cell B1 across to cell AF1
then move cell b8 to B34 inclusive up to B1
and adjust the coding to compensate for all of the moves
Finder V1.05jd_PH_multifind-FIXED AliGW.xlsm
Regards
Peter:)
Posted on EDxcell Forum Link to follow

Adjust coding to allow movement of cells
- Potholes
- Thread is marked as Resolved.
-
-
-
There is the potential for confusion here, so any and all responses should go in this thread: Correct coding so as to highlight in colour the cells correctly selected
-
I've tried to fix this, but I'm not sure exactly what it is supposed to do.
I've estimated what to change these ranges to
CodeActiveSheet.Range("B34").Value = Trim(MyFndTxt) ActiveSheet.Range("B1").Value = Trim(MyNTxt) ActiveSheet.Range("AB7").Value = LstFnd
Try this and let me know if it needs amending
-
I had disabled this thread because of the follow-on thread that Peter has started - there is the potential now for two conversations that are more or less about the same issue and that will (I know from experience) become confused. I did make a note about why I had disabled the thread - happy to go with the over-ruling, but wanted to make it clear why it was done.
-
I had started the reply last night, but forgot to post it
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!