EXcel VBA help - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Windows - 看得见风景的窗口

EXcel VBA help

EXcel VBA help# Windows - 看得见风景的窗口

s*r2005-06-28 07:06

1 楼

Here is an example, I need to search a row for a certain value, then I need to
search a colum for a certain value. Then I need to locate the value indexed b
y the row number and column which returned by my search.
How could I do it? especially when I use range object, how could specify the c
ell address by using the row number and column name which was returned by my p
revious search?
Also, to fill a column with certain pattern of values, when I write my VBA cod
e, I don't know how to let excel

r*y2005-06-28 07:06

2 楼

transferred to programming board.

【在 s*****r 的大作中提到】

: Here is an example, I need to search a row for a certain value, then I need to
: search a colum for a certain value. Then I need to locate the value indexed b
: y the row number and column which returned by my search.
: How could I do it? especially when I use range object, how could specify the c
: ell address by using the row number and column name which was returned by my p
: revious search?
: Also, to fill a column with certain pattern of values, when I write my VBA cod
: e, I don't know how to let excel

s*e2005-06-28 07:06

3 楼

I believe that u can find ur ans from msdn vba programming for excel. I used t
he online lib to help me code in perl. It was very helpful.

【在 r****y 的大作中提到】

: transferred to programming board.