[算表] Row函數一定要搭配Indirect函數嗎？
軟體:
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
→
10/06 21:45, , 1F
10/06 21:45, 1F
→
10/06 21:46, , 2F
10/06 21:46, 2F
→
10/06 21:46, , 3F
10/06 21:46, 3F
→
10/18 02:09, , 4F
10/18 02:09, 4F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
