Thread: Using a function in a macros to enter data in a specified cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Using a function in a macros to enter data in a specified cell
If you have the address of a cell in a variable, say sAddr, you
can use this variable with the Range property to access that
cell. For example,


Dim sAddr As String
sAddr = "A1"
Range(sAddr).Value = 123


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"MaxRussell" wrote in
message
...
I have identified a cell address using the "address" function. I
would like
to use the identified address to enter data into a cell using a
macros. Would
someone please help?


Reply With QuoteReply With Quote