Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple VBA - What's wrong??
Here's my sub-procedure, I am getting the error message "Subscript out of range". Please help, I am only wanting to set the cells value to a variable. Public Sub TEST() Dim strCellTest As String sCellTest = Worksheets("Sheet1").Cells(1, 1).Value Debug.Print sCellTest End Sub Also, how do I SET a cells value? Like this?: Worksheets("Sheet1").Cells(1, 1).Value = strNewVal Thanks in advance, ChrisB |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple VBA - What's wrong??
Chris,
Are you sure you have a worksheet named "Sheet1"? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ChrisB" wrote in message ... Here's my sub-procedure, I am getting the error message "Subscript out of range". Please help, I am only wanting to set the cells value to a variable. Public Sub TEST() Dim strCellTest As String sCellTest = Worksheets("Sheet1").Cells(1, 1).Value Debug.Print sCellTest End Sub Also, how do I SET a cells value? Like this?: Worksheets("Sheet1").Cells(1, 1).Value = strNewVal Thanks in advance, ChrisB |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple VBA - What's wrong??
"ChrisB" schreef in bericht ... Here's my sub-procedure, I am getting the error message "Subscript out of range". Please help, I am only wanting to set the cells value to a variable. Public Sub TEST() Dim strCellTest As String sCellTest = Worksheets("Sheet1").Cells(1, 1).Value Debug.Print sCellTest End Sub Also, how do I SET a cells value? Like this?: Worksheets("Sheet1").Cells(1, 1).Value = strNewVal Thanks in advance, ChrisB Are you sure Sheet1exist???????? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple VBA - What's wrong??
Chris,
Do you have worksheet called Sheet1? By the way, you dimension a variable called strCellTest, and then use sCellTest. Precede your code with Option Explicit! -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "ChrisB" wrote in message ... Here's my sub-procedure, I am getting the error message "Subscript out of range". Please help, I am only wanting to set the cells value to a variable. Public Sub TEST() Dim strCellTest As String sCellTest = Worksheets("Sheet1").Cells(1, 1).Value Debug.Print sCellTest End Sub Also, how do I SET a cells value? Like this?: Worksheets("Sheet1").Cells(1, 1).Value = strNewVal Thanks in advance, ChrisB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple multiplication of 2 cells = wrong product | Excel Discussion (Misc queries) | |||
What is wrong with this simple formula? | Excel Discussion (Misc queries) | |||
Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
Simple SUMIF formula gone wrong! | Excel Worksheet Functions | |||
Help! What's wrong with this simple copy and paste | Excel Programming |