Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code to find the max value in range E of a
worksheet. Option Explicit Sub findmax() Dim c As Range Dim x As Double x = Application.WorksheetFunction.Max(Range("E:E")) Set c = Range("E:E").Find(x, LookIn:=xlValues) If Not c Is Nothing Then c.Offset(0, 0).Select End If End Sub For example, if range E has values in first 50 cells and if cell E35 has the max value, present code selects cell E35. Instead of just having E35 selection, I would to have the full row 35 to be selected. Please let me know the code for this. This is the primary thing I am looking for. Secondly, the selected row (row 35 in this example) must be pasted in a row that does not have any values. In other words, if there is data in a row, then that row(s) must be skipped and the row35 must be pasted in a row that does not contain any data/values. Please let me know how to accomplish this. I would really appreciate any help. This problem has already consumed my 4 hours this morning.. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select next empty row from macro | Excel Programming | |||
Select next empty row from macro | Excel Programming | |||
how do i make a macro that will select all those cells that are empty | Excel Programming | |||
Select empty column & paste - Help please | Excel Programming | |||
Macro to select non empty rows in a given range | Excel Programming |