Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting a row by header row in VBA
I know this code probably isn't the most efficient, but i'm not worrie
about that, since it mostly does what i need. At the end, for th underlined, i needed to select a row, by the header row instead of th distance from the active cell. Sub McStatTol() ' Keyboard Shortcut: Ctrl+Shift+r Range("AK8").Select Do ActiveCell.Clear If Not ActiveCell.Offset(0, -1) & ActiveCell.Offset(0, -2) = " Then If ActiveCell.Offset(0, -2) ActiveCell.Offset(0, -1) Then ActiveCell.Value = ActiveCell.Offset(0, -2) Else ActiveCell.Value = ActiveCell.Offset(0, -1) End If End If ActiveCell.Offset(1, 0).Select _Loop_While_Not_ActiveCell.Offset(0,_-35).Value_=_\"\"_ End Sub Is there any way to say something like -Loop While Not 'ID Number' ""-? Thanks in advance, 00 -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Omit header from first page without embedding header in code | Excel Worksheet Functions | |||
Get Intersection value given column header and row header | Excel Discussion (Misc queries) | |||
Excel-Header-My Company Name won't work in Header (AT&T) & Time | Excel Discussion (Misc queries) | |||
Excel: custom header - is it possible to paste into header? | Excel Worksheet Functions | |||
how do I permanetly add custom header to excel header list? | Excel Discussion (Misc queries) |