Hi,
I know this is basic, but I can't get it to work!!
I am trying to insert numbers into the spreadsheet.
Code:
The books I have looked at show how to display numbers into a message box!
Sub TestPrint() Sheets("Sheet3").Select Range("A2").Select ActiveCell.Value = 5 End Sub
Also, does the formatting matter in the VBA Editor? Does an extra leading space here or there make a difference?
If I build an array in VBA, how do I display that on the worksheet? It will be 100 x 3 in size.
Thanks
As you write code directly, go ahead and break the habit of selecting cells/ranges prior to manipulating them. It's unnecessary and slows down your code. I would write your code above in one line:
Formatting doesn't matter, it's aesthetics. Properly indenting makes code easier to read, shows where new "sections of logic" start and stop. Ease of reading is so critical, this forum even requires posted code be in [ code ] tags for that very reason.Sheets("Sheet3").Range("A2").Value = 5
As for building an array in VBA memory, I've never done that specific thing, but I can't imagine it's difficult writing the array into a range like above. Something like:
Sheets("Sheet3").Range("A2:CV4").Value = MyArray
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
JB,
Thanks for your response. Regarding the array, is there a way I can specify a single cell and have the array start there? That way, I don't have to know the length of the array - it is n x 3? I would like to specify, say A10 as the starting point, and have the array fill in Col A,B and C.
Insect
As indicated, I haven't used arrays in memory in that manner, but if it were my first time, I would try using it the same way I would have used a Range to see if it worked...researched from there...something like:
I might have gotten lucky...MyArray.Copy Range("A1")
If I build an array in VBA, how do I display that on the worksheet? It will be 100 x 3 in size.Range("A1").Resize(100, 3).Value = MyArray
Entia non sunt multiplicanda sine necessitate
Hehe, awesome, SHG, my guess floweth nowhere. Next thing for me to spend time getting to know...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks