Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Paste Special in VBA
Name: Andy Date: April 29, 2003 at 12:45:21 Pacific OS: 2000 CPU/Ram: gig
Comment:
I'm trying to figure out the code to do the equivalent of paste special, values in Excel and am having trouble. Could somebody please help me out?
Name: hoang79vn Date: April 29, 2003 at 18:51:05 Pacific
Reply:
Ok, what is your prob? Don't you know how to record a macro in Excel and then review the recorded code in VBA???? It will help you alots in solving such kind of prob/. ;)
0
Response Number 2
Name: Andy Date: April 30, 2003 at 06:33:21 Pacific
Reply:
I really wasn't expecting that kind of response. Sorry that I am just starting to work with VBA and that I am learning everything on my own. I thought that's what this forum was for, to help out people who have questions.
Summary: i am interested in the formula with the help of which the information stored in horizontal row of book 1 can be paste special in to vertical row of book 2 ...
Summary: Hi I was wondering if anyone knows how to collect data from excel, and code it in VBA so it transfers it into a combo box in VBA, because i'm doing a project and i need the names of 4 teams that a...