Select range base on another Column

**Jerseynjphillypa** · 07-30-2012, 02:44 PM

I am trying to select column B, based on the range of column A.

Since Column B has some blanks cells. Since I treid to use this function for column B and it didn't work since the cells are blank

    Range(Selection, Selection.End(xlDown)).Select
    Range(Selection, Selection.End(xlToRight)).Select

Also once column B is selected convert the text to Numbers format

**nilem** · 07-30-2012, 02:53 PM

maybe so

'Range("A2", Cells(Rows.Count, 1).End(xlUp)).Offset(, 1).Select
Range("A2", Cells(Rows.Count, 1).End(xlUp)).Offset(, 1).TextToColumns 'convert the text to Numbers format

**Jerseynjphillypa** · 07-30-2012, 02:59 PM

Thanks for your help.
When I use the TextToColumns function, the numbers are still left align.

Aren't numbers in excel saved in the format as right align is a number and text is left align.

**arlu1201** · 07-30-2012, 03:00 PM

Try this

Select the whole column B and right click, select format cells and change the format to number with 0 decimal places.

**Jerseynjphillypa** · 07-30-2012, 03:17 PM

Thanks for all your help everyone.

**arlu1201** · 07-31-2012, 03:41 AM

Am glad it worked.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save