Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last column?
Hi. I have a way to find the last row in a column:
LastRow = Cells(Rows.Count, 1).End(xlUp).Row How would I find the last column in a row? Thanks! Mike. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last column?
for row 10 for example:
rwNumber = 10 lastColumn = Cells(rwnumber,columns.count).End(xltoLeft).Column -- Regards, Tom Ogilvy "Mike D." wrote in message ... Hi. I have a way to find the last row in a column: LastRow = Cells(Rows.Count, 1).End(xlUp).Row How would I find the last column in a row? Thanks! Mike. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last column?
Thanks, Tom.
Is there a way to refer to the column letter instead? I am trying to select all the columns with data in it by using the "Columns" command. For instance, Columns("A:C").select would select the first three columns. Is there a way to use the column numbers instead? Thanks again, Mike. -----Original Message----- for row 10 for example: rwNumber = 10 lastColumn = Cells(rwnumber,columns.count).End (xltoLeft).Column -- Regards, Tom Ogilvy "Mike D." wrote in message ... Hi. I have a way to find the last row in a column: LastRow = Cells(Rows.Count, 1).End(xlUp).Row How would I find the last column in a row? Thanks! Mike. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last column?
Columns(1).Resize(,3)
would be A:C But you could do Dim rng as Range set rng = Range(Cells(1,1),Cells(1,256).End(xltoLeft)) msgbox rng.entireColumn.Address -- Regards, Tom Ogilvy wrote in message ... Thanks, Tom. Is there a way to refer to the column letter instead? I am trying to select all the columns with data in it by using the "Columns" command. For instance, Columns("A:C").select would select the first three columns. Is there a way to use the column numbers instead? Thanks again, Mike. -----Original Message----- for row 10 for example: rwNumber = 10 lastColumn = Cells(rwnumber,columns.count).End (xltoLeft).Column -- Regards, Tom Ogilvy "Mike D." wrote in message ... Hi. I have a way to find the last row in a column: LastRow = Cells(Rows.Count, 1).End(xlUp).Row How would I find the last column in a row? Thanks! Mike. . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last column?
Thanks, Tom!
-----Original Message----- Columns(1).Resize(,3) would be A:C But you could do Dim rng as Range set rng = Range(Cells(1,1),Cells(1,256).End(xltoLeft)) msgbox rng.entireColumn.Address -- Regards, Tom Ogilvy wrote in message ... Thanks, Tom. Is there a way to refer to the column letter instead? I am trying to select all the columns with data in it by using the "Columns" command. For instance, Columns("A:C").select would select the first three columns. Is there a way to use the column numbers instead? Thanks again, Mike. -----Original Message----- for row 10 for example: rwNumber = 10 lastColumn = Cells(rwnumber,columns.count).End (xltoLeft).Column -- Regards, Tom Ogilvy "Mike D." wrote in message ... Hi. I have a way to find the last row in a column: LastRow = Cells(Rows.Count, 1).End(xlUp).Row How would I find the last column in a row? Thanks! Mike. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
Divide Column A by Column B multiply Column C | Excel Worksheet Functions |