Comments by JayyMehta (Top 14 by date)

=MAX(A2:G8)
@Laxmidhar Sahoo

10010 10011 10111 10110
1010 10111 10010 10011
11111 11110 10110 11100
11001 11110 10111 111
@ppolymorphe

So you mean, I can simply use the MAX formula..??

Well, I can... But what if the Numbers are in hundreds? and it has long descriptions.. plus if it has multiple tabs... Can't copy paste all...

I'm Sorry you didn't understand, but I have already mentioned in the question that "I'm trying to open a file..."

@marciej so that means that there's no major difference between these terms except the fact that the execution is faster with $...

I have created a simple table by colouring the cells and labeling them just two columns before the box cell. It's not literally a table, but just drew an outline border covering few range of cells... So, like that, i have created a cell for date, month and year... So, now if i select any input form combobox, the output should be displayed on those respective cells, ans also if i copy and paste that bordered range (table), the value should still be displayed just after two columns right to the label.

this is the code i wrote for adding items in combobox. Now, what i want is, when selecting a year or anything from it, the result should not be submit in a particular addressed cell. Instead I have created a table in excel itself and selected a cell inside that table for year output, a cell for month output and a cell for day output. If i drag that box anywhere in excel, even that values should move along with it.

Private Sub UserForm_Initialize()
Dim i As Integer
With UserForm1
For i = 1 To 31
.ComboBoxDay.AddItem (i)
Next
End With

Dim ctr As Long
For ctr = 1 To 12
Me.ComboBoxMonth.AddItem Format(DateSerial(YYYY, ctr, DD), "mmm")
Next ctr

With UserForm1
For i = 2017 To 1960 Step -1
.ComboBoxYear.AddItem (i)
Next

End With
End Sub