How to create macro with variable number of columns?

[JenniferGibbons1]

Hi, I have created a macro, but it is for a worksheet that has variable number of columns. In the code below, B7 will always be the start cell, but D35, could be E35 and so on, how do I deal with this please?

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

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, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[alansidman]

Remove your current Range statement

Insert the following in its place

Please Login or Register  to view this content.

[JenniferGibbons1]

Hi Alan,

Apologies for breaking the rules on my post, and thanks for amending it for me.

Jennifer

[JenniferGibbons1]

The code you provided didn't exactly work for me, it extended down too far. Is it ok for me to attach the worksheet so you can see what I am trying to create?

[alansidman]

To attach a worksheet, read the yellow banner at the top of the page

[JenniferGibbons1]

I also have a range of

Please Login or Register  to view this content.

- how would I write that with fixed rows and variable columns please?

Hi, please can you advise how to do this, and I think I can work the rest out on my own!
Thanks
Jennifer

[protonLeah]

Please Login or Register  to view this content.

*Cells(Row#,Column#)

[alansidman]

Thanks Ben. Didn't realize I had posted it backwards.

[JenniferGibbons1]

Thanks for that. I have attached what my worksheet should look like and also the code I have so far. Any comments would be greatly appreciated.

[JenniferGibbons1]

I also have a range of

Please Login or Register  to view this content.

- how would I write that with fixed rows and variable columns please?

[JenniferGibbons1]

I think I have it figured out!

Please Login or Register  to view this content.

[JenniferGibbons1]

Ok one last question please. How do I update this code to allow for variable columns please?

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

-2 because you are starting from column C not A

[JenniferGibbons1]

Thank you, thank you. I love excel!

[jolivanes]

Re:

Please Login or Register  to view this content.

How would I write that with fixed rows and variable columns please?
As you quoted but also

Please Login or Register  to view this content.

Note: Selecting should just about never be a requirement.
Google for instance
Why not using "select" in vba.
You should get lots of articles that'll explain why.