Copy only rows with data

[tkbuc]

I have this macro below that is auto-filtering my data and copying only specific columns to a new sheet.

The problem I am running into is that it is coping the entire column, including blank rows past the last row of data. How can I modify this to only copy the rows that have data?

Please Login or Register  to view this content.

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

[tkbuc]

Where do I place that in the code or do I replace something?

[AlphaFrog]

You replace the existing .Copy line.

[tkbuc]

I just did that and ran the macro. I get a Run Time 424 error stating "Object Required".

[AlphaFrog]

Please Login or Register  to view this content.

[tkbuc]

Wow! You are a wizard! It worked perfectly and ran 10 times faster than what I originally had! For this macro below, is there a way to speed it up?

'
' Reorder Columns
'

'
Sheets("Open Inventory").Select
Range("A1").Select
Columns("T:T").Select
Selection.Cut
Columns("A:A").Select
Selection.Insert Shift:=xlToRight
Columns("L:M").Select
Selection.Cut
Columns("B:B").Select
Selection.Insert Shift:=xlToRight
Columns("N:N").Select
Selection.Cut
Columns("D:D").Select
Selection.Insert Shift:=xlToRight
Range("A1").Select

[AlphaFrog]

Selecting ranges is not necessary and is time expensive.

Please Login or Register  to view this content.

[jeffreybrown]

Hi tkbuc,

If you notice in post #1 I added code tags for you and AlphaFrog has also used code tags as we request in the forum rules.

Administrative Note:

We would love to continue to help with your query; however, you need to include code tags around your code.

Please take a moment to add the tags in post #7. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly.

Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)