15,880,469 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Sleeper 11888211 (Top 7 by date)
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.
Show More