Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting the last non blank row.
I need to create a macro to select the last non blank row in a workshee
and then convert it into it's values ( the row has formulas on it, bu i will need the values only when the macro runs). I hope this make sense. Thanks for your help -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting the last non blank row.
To find the last USED row use this:
lastUsedRow = Worksheets("Sheet1").UsedRange.Row Worksheets("Sheet1").UsedRange.Rows.Count - 1 To find the first EMPTY row after the last used row omit the "- 1" lik so: firstEmptyRow = Worksheets("Sheet1").UsedRange.Row Worksheets("Sheet1").UsedRange.Rows.Count The same works with Columns: lastUsedCol = Worksheets("Sheet1").UsedRange.Column Worksheets("Sheet1").UsedRange.Columns.Count - 1 - Piku -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting the last non blank row.
Assuming your data was in column A, use:
Range("A65536").End(xlUp).Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone SkipBlanks:=False, Transpose:=False Application.CutCopyMode = False -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting the last non blank row.
Thanks.
Is there a way to copy and paste the whole row instead of only on column -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting the last non blank row.
Hi
try Range("A65536").End(xlUp).Select Selection.entirerow.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False Application.CutCopyMode = False -- Regards Frank Kabel Frankfurt, Germany Thanks. Is there a way to copy and paste the whole row instead of only one column? --- Message posted from http://www.ExcelForum.com/ |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting the last non blank row.
Change:
Range("A65536").End(xlUp).Select To: Range("A65536").End(xlUp).EntireRow.Select -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I delete blank rows from excel without selecting them? | Excel Worksheet Functions | |||
Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
Selecting non-blank cells | Excel Discussion (Misc queries) | |||
Selecting the first non blank cell in Range | Excel Worksheet Functions | |||
Selecting first blank row | Excel Programming |