Macro that helps me detect the last column with information

[tryingtoexcelatexcel]

Hi All,

Is there a macro that can help me detect the last column with information and then copy and paste data into the column to the right of that?

For example, I have information in column A and each week this information changes so I have been copying and pasting this information into the next blank column every week.

Now I have information in columns B to Z so this week I will insert a column then copy and paste A's information into column AA and this will update my graph.

Basically my graph now extends to AA so when I insert a column my graph will go to AB and I can paste the newest information into AA.

Not sure if this is the best way to do it but since I have around 35-40 graphs to update each week, this was the solution I came up with although in my graph there is always a blank at the end of the graph since it is linked to a blank column.

To summarize I have information in column A updated each week, my graph is linked to B-AA but there is only information in B-Z, I insert a column after AA (so new graph is B-AB) and I paste the updated info in A into AA.

Hope that is not too confusing.

Is there a macro that can help with this? Or better yet is there a macro that can update my graphs without having that blank space at the end. It does not bother me much but it would just help the graph look cleaner. Thank you very very much.

[BellyGas]

https://www.rondebruin.nl/win/s9/win005.htm

[kev_]

To answer the "last column" bit of your question

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[tryingtoexcelatexcel]

Thank you all, I am going to try all of your suggestions and then add in a copy paste command

[tryingtoexcelatexcel]

Hi All,

Sorry my title might have been a bit confusing. I was looking to move to the right of the last column with information in my excel sheet. So if my last column with info was AA, I'm looking for a macro that detects AA, moves to AB and then I can use a copy paste command (copy from A into AB or whatever the latest column is)

[mikerickson]

If your longest row is row 1, try this code

Please Login or Register  to view this content.

its directly analogous to the standard

Please Login or Register  to view this content.

[tryingtoexcelatexcel]

I'm using this code now:

Please Login or Register  to view this content.

But it the graph won't update, it seems to insert and copy but the graph does not seem to pick up the "insert part" . Not sure what is wrong here.

[tryingtoexcelatexcel]

Very odd.. when I manually insert a column the graph will update but when I use the code above, the graph won't. Any idea why?