paste a variable value into a cell?

[ronaldmacdonald]

Hi

Is it possible to assign a variable value to a specific cell in a workbook?

For example in workbook "a" i want to paste generated variables into cells a1,a2,a3,a4,a5,a6.

In my vbscript i am generating variables in a loop such as:

for i = 1 to 6
variable = i + 1
<paste &quot;variable value&quot; into <cell ax>
next i

the variable i accounts for the cell ranges a1 - a6
<cell ax> will range from a1 - a6

Cheers

Bill

 

[SkipVought]

Hi,

for i = 1 to 6
   variable = i + 1
   Cells(i, 1).Value = variable
next i

where Cells(row, col) is the reference
Hope this helps Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[ronaldmacdonald]

Just the job - worked a treat.

Thanks

Ronald

 

[bryanbayfield]

You just want to assign 1,2,3,4,5,6 - ie a data series to cells A1:A6?

No need for loops, two lines of code will do.

[a1] = 1
Range("A1:A6").DataSeries