Tuesday, 15 February 2011

vba - CDate Type dismatch -


I'm new to VBA I want to compare the time now with the meeting points, that I will get out of the compound cell But I get a type of Fetish error :-(

Sub Module 1 () No Time = CDT (time) as the Row Row as the string for the integer dim cell row = 1 on ActiveSheet.UsedRange.Rows.Count Step2 cell = "C" & Amp; rowCount Meeting Points = CDAT (['SAIL']) if time-on & gt; Tiegie points then lines (row number). Hyded = true lines (line C + 1). Hyded = True and if the next lineout ends sub

  MeetingEnds = cdate (['cell'])  

To do this I have a way to realize a lot.

Change:

  from meeting points = ['cell'])  

  meeting points = CDAt (ActiveSite.Range (cell))  

The reason for this, you can see the string of cell Sol are accumulated - C1, C3, C5 and more. Any reference must be attached or passed as a parameter for the range () method.


No comments:

Post a Comment