#1
|
|||
|
|||
How to return the first cell in a row?
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 also picture |
Thread Tools | |
Display Modes | |
|
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 |