Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding next available empty cell in a row
I'm having to transpose a lot of data that are currently arranged in rows to
columns, it's the output of a 1:m data table. I can't quite find the right syntax that activates the next available cell in a row above. Many thanks Wendy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding next available empty cell in a row
Set the start to the first cell to analyze. This will find the next
available cell in the same column. Set thecurrentcell = Worksheets("XXXX").Range("XXX") Do While thecalcedcell.Value < 0 Set thecalcedcell = thecalcedcell.Offset(1, 0) Loop "Wendy" wrote: I'm having to transpose a lot of data that are currently arranged in rows to columns, it's the output of a 1:m data table. I can't quite find the right syntax that activates the next available cell in a row above. Many thanks Wendy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding next available empty cell in a row
NextFree = Activecell.Offset(-1,0).End(xlToRight) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Wendy" wrote in message ... I'm having to transpose a lot of data that are currently arranged in rows to columns, it's the output of a 1:m data table. I can't quite find the right syntax that activates the next available cell in a row above. Many thanks Wendy |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding next available empty cell in a row
awesome,
thanks gentlemen, i'm sure i can figure it out from here! who knew? -m "Bob Phillips" wrote: NextFree = Activecell.Offset(-1,0).End(xlToRight) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Wendy" wrote in message ... I'm having to transpose a lot of data that are currently arranged in rows to columns, it's the output of a 1:m data table. I can't quite find the right syntax that activates the next available cell in a row above. Many thanks Wendy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding First Empty Cell in a Column | Excel Discussion (Misc queries) | |||
Finding First Empty Cell in a Column | Excel Discussion (Misc queries) | |||
Finding the first empty cell in a column | Excel Programming | |||
automatically finding the first empty cell | Excel Programming | |||
Finding the next empty cell. | Excel Programming |