Adjust coding to allow movement of cells

Potholes · Jun 4th 2020

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

https://www.excelforum.com/exc…of-cells.html#post5343425

**AliGW** · Jun 5th 2020

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

**royUK** · Jun 5th 2020

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

Code

ActiveSheet.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

**AliGW** · Jun 5th 2020

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.

**royUK** · Jun 5th 2020

I had started the reply last night, but forgot to post it

Adjust coding to allow movement of cells

Participate now!

Share