作者A1pha ([αλφα])
看板Office
標題[算表] Row函數一定要搭配Indirect函數嗎?
時間Wed Oct 6 17:32:03 2010
軟體:
Excel
版本:
2007/2003
請問一下,
Row()一定要搭配Indirect()嗎?
我會問這一個問題是因為,為了查一些資料我回去翻了一下以前買的書,
結果發現,書上教的是,利用Row(Indirect("1:10"))來代替{1,2,3,4,5,6,7,8,9,10}
問題是,
這方法我用了很久,但是根本就沒用Indirect啊@@"
就直接Row(1:10)就好了啊,幹嘛那麼麻煩還打個Indirect那麼多個字母@@"
有人知道那樣做(加入indirect)有什麼好處嗎?
--
"Every kid who has dreamed of being a baseball player has stood in his front
yard with a bat and said to himself, "Bottom of the ninth, Game 7 of the
World Series, the bases are loaded," and then envisioned hitting a home run
to win the game. My job is to shatter that dream."
By Huston Street
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 210.202.55.129
→ windknife18:應該沒差,除了你的資料會有變動,才可能會發生問題 10/06 21:45
→ windknife18:例如 第一列 被刪除,那麼 indirect 沒影響,另一個 10/06 21:46
→ windknife18:就會有影響 10/06 21:46
→ A1pha:嗯嗯~~ 感謝 QQ 10/18 02:09