Importing selected cells into VBA

**tryer** · 10-12-2008, 05:00 PM

Can you help with how to import into vba just the data in the currently selected cells?

What I want to do is to manually select a range of rows (in a single column) and upon running the macro put the data from each cell into the uppermost cell with each seperated with a comma.

I can manage the combining of the data but don't now the selection is read into VBA

**VBA Noob** · 10-12-2008, 05:16 PM

manually select a range of rows (in a single column)

Do you mean a range of cells in one column

VBA Noob

**tryer** · 10-12-2008, 05:21 PM

Yes, sorry if I didn't explain clearly

**VBA Noob** · 10-12-2008, 05:23 PM

See if this helps

Please Login or Register  to view this content.

VBA Noob

**tryer** · 10-12-2008, 05:45 PM

Thanks Noob that works a treat.

Is there a way to delete the cells below selection(1) ? at the same time?

**VBA Noob** · 10-12-2008, 05:46 PM

Add

Please Login or Register  to view this content.

after

Please Login or Register  to view this content.

VBA Noob

**tryer** · 10-12-2008, 05:48 PM

Noob this works perfectly. However I'm struggling to understand the line

Please Login or Register  to view this content.

presumably Selection (1) selects the first cell in the range but don't know what the 9^9 bit does?

**VBA Noob** · 10-12-2008, 05:52 PM

I use the mid function to get rid of the extra comma at the start.
Type =9^9 in a cell and it returns 387420489. This makes sure it shouldn't cut off any cells at the end of the mid function

Selection (1) selects the first cell in the range

Correct

VBA Noob

**tryer** · 10-12-2008, 05:54 PM

Thanks that's great

Importing selected cells into VBA

LinkBack

Thread Tools

Rate This Thread

Display

Importing selected cells into VBA

trying to understand

Thread Information

Users Browsing this Thread

Similar Threads

average of cells from user selected range of worksheets

bug: cells selected as mouse moves

Manual calculating selected cells only

importing text but it spreads across cells

Bookmarks

Bookmarks

Posting Permissions