看板 Office 關於我們 聯絡資訊
軟體: 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