Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Urgent - VBA procedure
=OFFSET(INDIRECT(ADDRESS(MATCH(908,$A:$A,0),1,2,), TRUE),1,16)
I need help to design a VBA procedure, based on the formula above, that would allow me to input with an Inputbox the several customer numbers (in this case 908) to be added in row T8 -- Regards, Jeff |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Urgent - VBA procedure
Jeff,
Try this Dim iMatch As Long On Error Resume Next iMatch = Application.Match(908, Range("A:A"), 0) On Error GoTo 0 If iMatch 0 Then MsgBox ActiveCell.Offset(iMatch - ActiveCell.Row + 1, 16 - ActiveCell.Column + 1) End If -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Jeff" wrote in message ... =OFFSET(INDIRECT(ADDRESS(MATCH(908,$A:$A,0),1,2,), TRUE),1,16) I need help to design a VBA procedure, based on the formula above, that would allow me to input with an Inputbox the several customer numbers (in this case 908) to be added in row T8 -- Regards, Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy entries short procedure required | Excel Worksheet Functions | |||
VBA Compile error: Procedure too large? | Excel Discussion (Misc queries) | |||
Very Urgent VBA Procedure | Excel Discussion (Misc queries) | |||
execute stored procedure from excel | Excel Worksheet Functions | |||
Urgent Urgent Urgent!!! | Excel Discussion (Misc queries) |