Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Grant Young   on Sep 17 In MS Office Category.

  
Question Answered By: Julia Silva   on Sep 17

I've been meaning to find out if this worked. Have named
cells all along, but not since getting into VBA SUPER! Now I can
move things around and not have to parce my code for the references.

FYI, Abhishek,
You reference cells like this (absolute) too (some code snippets):

Get from the sheet  to VBA
f = ActiveSheet.Cells(Row, Col).value ' (.value is optional)
PortName = ActiveSheet.Cells(1, 12).Value

Going the other way
ActiveSheet.Cells(r, 2) = ModeName

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on how to get data into vba variable Or get search suggestion and latest updates.


Tagged: