Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ranges and Arrays
I have two questions, and before I ask them there is one thing you
should know: I'm a newbie. Question 1: I am making an encryption program for an IT project. I need to have the user type in (via a userform) a string, have the program take a character from the string and then put that into a sheet, first char in A1, second in A2, etc., which does calculations on the character to encrypt it. I can figure out how to code all of it besides the put the characters into a sheet part. I thought the easiest way would be to do this: Dim char As String Dim text As String Dim i As Integer While i < len(text) char = Mid(text, i, 1) (range code here).Value = char Wend but I have no idea how to make it put it in the right range! Is there a way to make it so that the program puts the value of char into a range based on i, like Sheet1.Range("A" + i) (that doesn't work, I already tried)?? Question 2: Is there any way to create an array (like a matrix) in excel without writing to a sheet? Thank you very much for your time, and your help is very much appreciated!!!! Will Brown *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ranges and Arrays in Excel VBA | Excel Worksheet Functions | |||
comparing ranges/arrays | Excel Worksheet Functions | |||
Help with Arrays & Ranges in VBA | Excel Programming | |||
Transferring ranges to/from arrays | Excel Programming |