View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
CodeIT CodeIT is offline
external usenet poster
 
Posts: 1
Default Retrieving Data From Excel

On Wednesday, September 10, 2014 6:43:12 AM UTC-5, Asad wrote:
Hey Guys,





I want to Retrieve data from Excel cell Possibly Cell A,



Can any body direct me how I can do that?



Regards

Asad


xyz= range("A1").value
' read value in A1 and assigns to variable xyz
range("B1").Value=xyz
' assigns value of variable xyz to cell B1
range("B1").Value= range("A1").value
' read value in range A1 and assigns to range B1

2code