Improving existing macro to flip data

**axtryo** · 10-18-2017, 02:42 AM

Hi all,

I currently have a working macro which I'd like to improve. Its only purpose is to flip the data for as many rows and columns the sheet has, leaving headers alone.

I mostly need to set the range in a better way (I know its current code can definitely be improved!).

Is there a better/easier code way to achieve the flip? (Please note I do NOT need the data to be sorted "A-Z", "Z-A" or any other sort Excel might have. I just need the data to be flipped).

Thanks for any help!

Please Login or Register  to view this content.

**Kaper** · 10-18-2017, 03:42 AM

With Range("A1")
.Value = 0
.AutoFill .Resize(10, 1), xlFillSeries
End With

Try:

Please Login or Register  to view this content.

**Kaper** · 10-18-2017, 03:46 AM

PS. You use Sort object now. sorting can be also done as range method with shorter code so instead of whole:

Please Login or Register  to view this content.

you can write just one line:

Please Login or Register  to view this content.

**axtryo** · 10-19-2017, 01:46 AM

Hey Kaper!,

Will try the code tomorrow (Thursday for me) and will let you know if it worked. Thank you so much!

**axtryo** · 10-20-2017, 01:33 AM

Hi again Kaper,

Your code worked like a charm! Thank you so much! Marking this thread as solved.

**Kaper** · 10-20-2017, 03:05 AM

Hi,

Glad to hear that, and thanks for marking thread as Solved.

It would be lovely if you colud also "add me some reputation" by clicking a small star icon in lowerleft corner of my post(s). (and confirming that "you agree").

Improving existing macro to flip data

LinkBack

Thread Tools

Rate This Thread

Display

Improving existing macro to flip data

Re: Improving existing macro to flip data

Re: Improving existing macro to flip data

Re: Improving existing macro to flip data

Re: Improving existing macro to flip data

Re: Improving existing macro to flip data

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Transposing Data Macro (flip columns)

Improving my existing macro to filter based on more than one criteria

Improving existing macros

[SOLVED] Improving existing VBA code and removal of unwanted row

[SOLVED] Need to Transpose and Flip Table of Data - Macro Probably Needed

Improving an existing macro to autofill all columns, not just column A

employee planner, improving existing model

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions