Search results

Hi Brian, 'Only' 10 miles, eh? Dim wStroll As 10mileWalk For Each wStroll In Merseyside wStroll = Delete Nomadscot Next wStroll I'm not a walker. :) Love the canals though. Had a narrowboat once, and spent a lot of time cruising around England...

Wise indeed. :) I've also been Googling this issue extensively, without success. Until now. I now have an issue with the 'Cut and Paste' element, which is not going as smoothly as I would have hoped due to the method for Cut & Paste being different to that for Copy and Paste. The problem being...

No sir, not misleading at all - most helpful! It's my inexperience that's at fault here. That 'simple test' works fine for me too - thank you very much indeed. In answer to your second reply, I merely shortened the range (from col T to col E) to test the code in a separate blank workbook...

Hi Brian, My apologies for not coming back to you sooner - just got home a short while ago. Also thanks for your reply. I wonder what's causing the difficulty in replying. Could it be something I'm doing wrong? I tested your code as noted below, but unfortunately it fails (Method range of...

Good Morning Brian, Thanks so much for your prompt reply. What I'm stumbling over is selecting the range. It would be the code for this: Range("Last populated cell in Column A:Last populated cell in column T").Select Once again, I appreciate your input very much. Thank you.

Good morning. I wonder if someone can help me with this VBA problem please. I need to 'Cut' a Range which starts from the last populated cell in column A to the last populated cell in Column T. I then need to paste those 'Cut' cells elsewhere on the same sheet. I can define the 'Paste'...