Please explain why I'm getting a syntax error?

[Old4xford]

So I'm building up this Frankenstein VBA code project from snippets I'm finding online and I have this put together:

Please Login or Register  to view this content.

Now, when I run it with an actual number in "columncount = 250", it works fine. But when I change it to "columncount = Application.WorksheetFunction.CountA(1:1)", I get syntax error. What have I gotten wrong in there?
Also, I have tried "columncount = Application.WorksheetFunction.CountA("1:1")", but it only runs once through the loop and then quits.
Can someone please point out what the VBA newbie is missing?

[walruseggman]

Try:

Please Login or Register  to view this content.

[Old4xford]

Wow, that works great! But I don't have any idea what any of it means. Could you please explain it?

[GeneralDisarray]

To see what this means try this in a blank workbook.

1) Type anything into any cell in the first row, say K1, then press enter.

2) Hold down the control key and press the right arrow one time, then the up arrow one time. You should end un on cell XFD1.

**XFD is the last column, number 16,384. Cells(1,columns.count) refers to this cell (columns.count = the total number of columns in the worksheet)

3) Now that you are on cell XFD1 - press the "End" button on your keyboard one time (press and release, don't hold down).

** You have just put Excel into "End Mode"

4) Press the left arrow one time - you should end up on cell K1 where you typed something. Google end mode if you've never heard of it https://blogs.office.com/2011/09/06/...sing-end-mode/


CELLS(1,COLUMNS.COUNT).END(xlToLeft).column -> that mimics what you did on the keyboard (mimics it logically, without actually doing it) - it's a common way of finding the last column :D

[Old4xford]

Aha, ok then. Thank you both so much.