Can't get offset to work

[lizpete]

All day I have been reading my textbook, looking in MSExcel help, and doing online searches with no success to find out more about the offset function. Below I am posting my code, you probably will find it very simple and I hope you don't laugh at me. Anyway I cannot get the offset function to work. The results of this sub is that it prints the numbers (one at a time, in "A2" on Sheet3. I have a MsgBox which stops it each For each . . . it goes 1 then 2, then 3, etc. up to the correct number of days in the month that I choose. But they are all in the same box, in A2, right where I want it to start. But of course I want the numbers to fill in the cells A2 & below A2 instead of replacing the one last in A2.

Can any of you smart people find what I did wrong?

Thank you very much!

Betty


Option Explicit

Please Login or Register  to view this content.

[protonLeah]

Since your index variable, i, starts at 1, you can use:

Please Login or Register  to view this content.

(in this case)

[lizpete]

Please Login or Register  to view this content.

Moderator's Note: Welcome to the forum, Codes should be enclosed with code tags. Select the code then hit the "#" sign. I'll do it for now. Thank you for joining the community.

[lizpete]

Maybe I did something wrong. You can see your suggestion in the code. It *did* start in A1 this time, with a 0 but the other numbers all appeared in A2 and rotated through all of them -- until 31 when it quit. (I chose the month of January.)

Boy.

Thank you, though, I'm sure it is something I should know.

Betty

[jaslake]

Hi Betty

Notice the difference

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[lizpete]

Are you saying that in the () it should be 1, 0 ?

Actually I tried them both and they both stayed in the cell "A2" and never filled the cells below.
??

Thank you, though! :-)
Betty

[jaslake]

Hi Betty

This

Please Login or Register  to view this content.

should be this

Please Login or Register  to view this content.

Not 1 but i
Not tested...just looking at the code and seeing what you wish to do.

[lizpete]

You didn't see my response? Maybe it wasn't clear.

I tried with both i and 1 with the same effect, oddly. You would think "something" would be different.

Oh, somehow I didn't get it posted.

Betty

[jaslake]

Hi Betty

I have Grandson duty in the AM and am about to retire for the night. If you don't have a resolution by the morning I'll build a worksheet that emulates your issue and, hopefully, a suggested resolution.

Good night.

[lizpete]

Thank you very much!

Betty

[jaslake]

Hi Betty
This code works for me

Please Login or Register  to view this content.

[lizpete]

Now it doesn't work again. I just pasted it into my program. I put it onto a public link in my storage area -- https://files.secureserver.net/1f5icDhIlTSYW6
password is vbacode

so you could look at the behavior in my file if you get time with your grandson today.
You can find it on tab A-L

Thank you very much.

[jaslake]

Hi Betty

Look carefully at the code

Please Login or Register  to view this content.

[lizpete]

I cannot believe it. It works now that I re-pasted the code. I cannot believe it. I need new glasses, I know I do. I guess the i makes the difference. Each "for each" it adds 1 to the offset. And when you put it before the "for each", that's starting it at the right place. It does make sense.

You can see it work in the storage space now.

I will study it more this evening just to make sure I understand it.

Thanks for your great patience with me.

Betty

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.