Retrieving Data From Excel

[Asad]

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

 

[dguillett]

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

There is no cell a... there is a cell a1, a44, etc.
always fully state what you want and why

 

[Gord Dibben]

Retrieve to where?

Data is in A1

Formula in B1 =A1

Gord

 

[dguillett]

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

Hey Gord, where have you been (down under)

 

[Gord Dibben]

Hey Gord, where have you been (down under)

Hanging out a bit over in MS Community with occasional forays here but
slowly fading away like old soldier as health and interest wanes.

Good to hear from you. . . .Hookem Horns

Gord

 

[L. Howard]

. . .Hookem Horns

Gord

Hi Gord,

Better get your game face on! Pac 12 UCLA comin' up and my wife's Oregon Ducks sorta had their way with The Horns in their last bowl game.

Take care.

Howard

 

[dguillett]

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

I'm Don Guillett from Austin TX and Gord knows that and was saying "hook em" to
me. We will need some luck as this is a building season for new coach but make no mistake, it is HIS team and they will ultimately do well.

 

[CodeIT]

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