Selecting & copying a variable range

**KaitMacN** · 08-26-2011, 08:57 AM

Hello

I am having trouble coming up with the proper code to select a variable range.
The situation is that I have courses that have a various numbers of students emailed to me in a select format and I want to be able copy that information into a new sheet and have the information re-organized and pasted into a new master list.

Since I was unable to sort out the variable codes I have been selecting many more cells than necessary with a very messy code!

I have included a modified version of the file that will hopefully make sense

Thanks!

**tigeravatar** · 08-26-2011, 10:09 AM

KaitMacN,

Attached is a modified version of your Unit workbook. The Paste macro has been deleted and the object assigned to the Paste macro has been reassigned to the Copy macro. In the 'Entry' sheet, rows 55 to 105 have been deleted including the object that was assigned to the Copy macro. All you need to do is click the object in the 'Master' sheet to run the new Copy macro to pull in information as desired. The Copy macro has been updated to the following:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

**KaitMacN** · 08-26-2011, 12:35 PM

Thanks so much! That is a much more elegant and effective code AND it actually does what I wanted unlike mine :P

Selecting & copying a variable range

LinkBack

Thread Tools

Rate This Thread

Display

Selecting & copying a variable range

Re: Selecting & copying a variable range

Re: Selecting & copying a variable range

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions