Selecting range using .range. But can you do same selection using .columns

**welchs101** · 07-01-2011, 09:20 AM

I know how to select a range of cells using code similar to the following:

Please Login or Register  to view this content.

i have a function called alphacol which converts lst_row number to character equivalent.

What i was wondering is .......is there a way to select range using the .columns

I know i can select individual cells using .columns ....such as

Please Login or Register  to view this content.

But i dont know how to select a range using the column method.

**welchs101** · 07-01-2011, 09:27 AM

ok....i actually had an error in my first code but this error should not effect my question

corrected code:

Please Login or Register  to view this content.

**romperstomper** · 07-01-2011, 09:34 AM

None of that code will work. I suspect you are thinking of the Cells property rather than Columns?

**welchs101** · 07-01-2011, 09:35 AM

ok....showing my ignorance..........its not .columns but rather .cells i think that i am referring to.

For example: How to select a range using the .cells method

Please Login or Register  to view this content.

**welchs101** · 07-01-2011, 09:35 AM

romperstomper...........did not see your reply before i posted mine..........your really on top of things. sorry for the confusion.

**romperstomper** · 07-01-2011, 09:38 AM

The last code you posted will work, assuming the right sheet is selected first.
However, it is very rarely necessary to actually select cells in code.

**royUK** · 07-01-2011, 09:39 AM

You don't really need to select a Range

Please Login or Register  to view this content.

I don't know what this is

alphacol(lst_row

**welchs101** · 07-01-2011, 09:44 AM

hi guys,

What i want to do is filldown some data from cell 1 to say cell 10,000. I know the value i want to filldown its a constant.

Normally i do the filldown such as this:

Please Login or Register  to view this content.

i was just curious if there was a way to do the same thing using a .cell

This is kind of a bad example but usually when i have to select ranges using the .range method i have to specify a col letter and i was wondering if there was a way to get around this ...........thoguht may be about the .cells.

**romperstomper** · 07-01-2011, 09:48 AM

You can use resize, or use Cells with Range:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**welchs101** · 07-01-2011, 01:31 PM

thanks. I like the resize option for this answer.

Thanks.

Selecting range using .range. But can you do same selection using .columns

LinkBack

Thread Tools

Rate This Thread

Display

Selecting range using .range. But can you do same selection using .columns

Re: Selecting range using .range. But can you do same selection using .columns

Re: Selecting range using .range. But can you do same selection using .columns

Re: Selecting range using .range. But can you do same selection using .columns

Re: Selecting range using .range. But can you do same selection using .columns

Re: Selecting range using .range. But can you do same selection using .columns

Re: Selecting range using .range. But can you do same selection using .columns

Re: Selecting range using .range. But can you do same selection using .columns

Re: Selecting range using .range. But can you do same selection using .columns

Re: Selecting range using .range. But can you do same selection using .columns

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions