Repeat simple Macro

Hi,

Try this (untested):

Please Login or Register  to view this content.

I hope this helps

Hi Alan,

My apologies, and thank you. I have now read all of the rules

ajryan88 - thank you very much, too. I tried it, but receive an error '438' - Object doesn't support this property method. Any ideas? I have attached the workbook. It is in the "RemoveWrap" Sub. Basically, the program that is spitting out my .csv/Excel file is for some reason inserting an inadvertent line wrap after the city/state (cells D2, D4, etc.) and the values that start at B3, B5, etc are supposed to be up in the E2, E4, etc cells. The programmers have confirmed that this is a bug in the original program so I'm trying to use Excel to fix it. I am a total newbie when it comes to excel macros and VBA, but am very interested in learning. I've tried all sorts of google searches, but have a hard time translating other solutions to my specific need. Your help is extremely appreciated!

To attach a file, click on Go Advanced (bottom-right of the Quick Reply window), and then Manage Attachments

Ah, thank you. WithLocation.xlsm

Sorry, the reason it isn't working is my fault...I accidentally pasted the wrong code above. The Paste method is a worksheet method, not a range method. Use this code instead and you should be all sweet:

Please Login or Register  to view this content.

Let me know how you get on

Thank you!!! It ran without an error, but there was still something strange going on with the rows. I realized it was because the row needs to be deleted after the B:N cells are cut. So I experimented with a few things and finally got it to work perfectly! I appreciate your help so much, I would have never known how to get it started and I learned a little along the way.

The only thing I need now is to apply it to ALL worksheets/tabs in the excel file. How would I do that? Something like "With ThisWorkbook.Worksheets("All")?

This is what I ended up using (same as yours, except with the delete row command). Is that how you would have gone about it?

Please Login or Register  to view this content.

Sorry, I thought when you said "delete rows" in your OP you meant "clear the contents", but after seeing the actual format of your data from your attachment above, I realise that you actually meant "delete rows".

To do this for all worksheets, use the following code (I have started with your code from the previous post, altered the way in which rows are deleted, and added the worksheet loop):

Please Login or Register  to view this content.

I changed the way the entire row is deleted because it isn't necessary to select a cell/range to delete it, and your code will run faster if you don't select everything before operating on it -- you will notice that I made similar changes from your original code to get to the code that I pasted above...

I hope this helps

You are very kind for helping. Thank you

I'm noticing now that the last range of cells to be cut/pasted are actually gone (see image 1). Also, there is an error "1004" after it completes the first worksheet.

I've attached a workbook that has two worksheets for you to experiment with if you'd like.

image1.jpg
Test.xlsx

Works beautifully! You're the best Many, many thanks to you.

No worries

Please don't forget to mark this thread as solved (Thread Tools --> Mark As Solved), and please click on the * next to my post to say thanks

Done! (thanks for showing me). Do you mind if I post the code on my blog? It will help architects who want to use 3ds Max Design for daylighting analysis. 3ds Max Design is the program that exports out the CSV files with the extra line wrap in the data.

My blog: http://bimchicks.com