how can I get the maximal used column in the specified row?
 

I want to append some information to a specified row. I only know using
ctrl+End can get the last cell in the whole sheet, but how about just
the last cell in a row? Thanks.

how can I get the maximal used column in the specified row?
 

end & down arrow will get you to the last cell before a empty one,
got to a search engine and type in 'excel tips and tricks' and you will
find many pages of short cuts
dave

how can I get the maximal used column in the specified row?
 

I am sorry that I did not state clearly. what I want to do is using VBA
code to do the operation. Thanks.

how can I get the maximal used column in the specified row?
 

this will give you the last row in column a

lastrow = Worksheets("Sheet1").Cells(Rows.Count, "A").End(xlUp).Row

so range("A" & lastrow +1) would be the next row to add something

change the sheet and column reference to your need
--


Gary


"lvcha.gouqizi" wrote in message
oups.com...
I want to append some information to a specified row. I only know using
ctrl+End can get the last cell in the whole sheet, but how about just
the last cell in a row? Thanks.