Simple Looping Help

[vexel77]

Hi,

I have data in Range A3:A33 in an activesheet. I have the following piece of code that edits the data in range A3 and pastes a new value into C3. Could someone help me write a loop that cycles through each cell in the range of data and performs the editing task?

Please Login or Register  to view this content.

Many thanks

[Leith Ross]

Hello vexel77,

Welcome to the Forum!

What does a name in cell A3 look like?
What will the name in cell C3 look like?

[vexel77]

Hi, Thank you!

a3 = T Pastornicky SS
c3 = T Pastornicky

Many thanks

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[vexel77]

That's worked perfectly, thank you so much.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

[Leith Ross]

Hello vexel77,

Here is another way to do it...

Please Login or Register  to view this content.