How to return the first cell in a row?

dapeamel · #1 02-26-2015, 12:56 AM

Hi guys

I use this code but I still dont get the first cell in the same column and row 1

see code below:

Code:

Sub Langauge_Combination() 


For Each sht In ActiveWorkbook.Worksheets
Set Rng = sht.UsedRange

Set MyRange = Rng
For Each MyCol In MyRange.Columns
For Each MyCell In MyCol.Cells
'MsgBox ("Address: " & MyCell.Address & Chr(10) & "Value: " & MyCell.Value)

If MyCell.Interior.ColorIndex = 23 Then

'MsgBox MyCell.Text

' Put code here

MsgBox "" & MyCell.End(xlUp).Text 'I DONT GET THE FIRST ROW WHY?


End If
Next
Next
Next

End Sub

See example file

also picture

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Search for multiple texts in cell, return specific text	mariur89	Excel	4	12-14-2014 01:33 AM
Would like to return a row rather than a cell using VLookup	canajun	Excel	7	12-10-2014 01:03 PM
Reference another workbook and return values from the same cell across multiple sheets/tabs	lwls	Excel Programming	5	11-08-2014 02:11 PM
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to?	bharathkumarst	Excel	7	10-13-2014 10:25 AM
Return cuurent time when another cell is updated	zks	Excel	6	01-22-2012 10:24 PM