Re: HELP -> Perl 'Hash' Functionality Required In VBA

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

just to expand on the 'find' method which worked ok for me, can
someone tell me how I can recall the row & column number when the find
is succesfull, the code I am using is detailed below:

CheckData = "abc"
set c = worksheet("sheet 1").columns("A").find(what:=Checkdata, _
lookin:=xlvalues,lookat:=xlwhole)
if not c is nothing then


msgbox "Found the data: " & Checkdata"
else
msgbox "Could not find : " & CheckData
end if



cheers.
.

Relevant Pages

  • Re: HELP -> Perl Hash Functionality Required In VBA
    ... someone tell me how I can recall the row & column number when the find ... is succesfull, the code I am using is detailed below: ... CheckData = "abc" ...
    (microsoft.public.excel.programming)
  • RE: Duplicate rows into new rows based on row value
    ... That's right I am looking to expand the data. ... the first row (2 ABC) will eventually be two individual rows because of the ... I am trying to breakout multiple rows into individual rows based on a value ... 3 DEF 2.3 ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Expanding a bronze bushing?
    ... it fits the ID of a tube. ... I seem to recall there was a way to expand the OD slightly with ...
    (rec.aviation.homebuilt)
  • Re: Expanding a bronze bushing?
    ... it fits the ID of a tube. ... I seem to recall there was a way to expand the OD slightly with ...
    (rec.aviation.homebuilt)
  • Re: Epsteins gone man.
    ... I was MUCH more a fan of "Whats Happening!" ... was on at the same time as "Kotter"...but on ABC, if I recall. ... Kotter was on ABC. ...
    (rec.music.gdead)