Re: Shapes object events?

Tech-Archive recommends: Fix windows errors by optimizing your registry


avveerkar Wrote:
> I am again sorry, I am still not with you. By number of lines do you
> mean number of used rows in a work***? Or you are referring to number
> of lines of code of your procedure? If it is later case then I do not
> know what exactly you are referring to because I cannot visualise a
> situation where number of code lines can change. In the former case,
> are you saying that the number of rows used is not fixed and you want
> to write a procedure to first find out how many rows are used and once
> you know the number then you want to evluate those rows? There is a
> method called CurrentRegion which will return a used range and then
> using Rows.Count you could find out number rows in the range. Is that
> what you are looking for? Else you need to tell me what exactly is your
> application. Sorry for being such thick-headed.
>
> Don't be sorry...I'm very happy that someone is interested in my
> problem. I'll try again. I have a procedure which import DXF (AutoCad)
> into Excel. Lines in Autocad becomes Lines in Excel. I can draw any
> Number of lines in Autocad so I don't know for their number till I run
> procedure which import DXF in Excel. Now I have their number and the
> procedure already draw them all (in Excel). But here the main problem
> appear: how can I assign a macro to all lines by VBA. I can do this
> manual (clik first line, assign macro, click second...like you suggest
> in first reply). I want to VB do that for all lines.
> Dr.Ile


--
Dr.Ile
------------------------------------------------------------------------
Dr.Ile's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15975
View this thread: http://www.excelforum.com/showthread.php?threadid=506688

.

Quantcast