Comments by Sleeper 11888211

Sleeper 11888211 5-Jul-22 10:23am View

I have this working, though I am partially hard coding the range. I do find the last row needed by code, so that's the hard part. I am trying to see what I have wrong from your code.

Aside from that, how do I maintain the source's formatting?
Thanks,
Paul

Sleeper 11888211 1-Jul-22 18:57pm View

@Chill60-
I looked at your code and realized the code transfers all the data in the source to target. What I have is a single row of target formulas Y2 through AI2. A second worksheet has data in a variable range, say A1:X1000. Each target row needs the formula row transferred from the source Y2:AI2, down the rows to the Last_Row, meaning one row of formulas for each row of data. I do this by looping through a copy/paste of source's single row, copied into each row of target. I test for the end row, so it is exactly the number of rows (copies) I need. I disable calculation and screen updates before the loops, but it is still slow. (sorry if duplicate. It seemed to hav frozen) S.

Sleeper 11888211 1-Jul-22 18:48pm View

Deleted

@Chill60-
I looked at your code and realized the code transfers all the data in the source to target. What I have is a single row of target formulas Y2 through AI2. A second worksheet has data in a variable range, say A1:X1000. Each target row needs the formula row transferred to the source Y2:AI2, down the rows to th e Last_Row, meaning one row of formulas for each row of data. I do this by looping through a copy/paste of source's single row, copied into each row of target. I test for the end row, so it is exactly the number of rows (copies) I need. I disable calculation and screen updates before the loops, but it is still slow.

In thinking on it, maybe I could copy the formulas down on the sheet that has the need formulas and get the last row from the destination sheet and use that to get the range to be transferred.

I'll ave to research obtaining a variable in oe sheet and using it in a second one. I've done VB.net programming in an amateur way, but this is my first foray into Excel VBA.
Thanks for the interest in my problem!!!
Sleeper

Sleeper 11888211 30-Jun-22 20:15pm View

Deleted

@Chill60- thanks so much!!

Sleeper 11888211 11-Nov-21 13:01pm View

Thanks Richard!

I added %20 to substitute for spaces:
New York ---> New%20York
and it worked as expected.

Sleeper 11888211 29-Jul-16 15:42pm View

Thanks! I'm not a professional- it's my hobby!

Sleeper 11888211 27-Jul-16 16:12pm View

Thanks. I will try to read it byte by byte and see what that brings. I figured there were other non-visible characters. Pointers are always welcome for this hobbyist.

Comments by Sleeper 11888211 (Top 7 by date)