vba printing

[ottasight]

HI
need all the ways to print a vba variable into a single cell and range of cells on a spreadsheet. IE1. for x = 1 to 5, print(a,x) = x, next x. IE2. print(a10)= "mynumber"..........thanks

 

[bensonsearch]

if you are wanting to put a variable into a cell

dim asd as string
asd = "Hi"
thisworkbook.sheets("Sheet1").range("A1").value = asd

if you wanted to loop then

dim count as integer
dim asd as string
 
count = 1
 
do until count = 6
thisworkbook.sheets("Sheet1").range("A" & count).value = asd
 
count = count + 1
loop

 

[bensonsearch]

if you wanted to print what was there then

range("A1").printout