Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Cells
Hello. I have a sub that iterates over some cells in my worksheet. So
something like this: CurRow=1 Do While (CurRow <= 1000) CurCol = 1 Do While (CurCol <=1000) Worksheet.Cells(CurRow, 1) .Value = ComputeValue(CurRow, CurCol) CurCol = CurCol + 1 Loop CurRow = CurRow + 1 Loop I want to select some of those cells during the iteration, but don't have good way to select a range. For instance I want to be able to do something like: Worksheets.Range(CurCol & CurRow & ":" & CurCol + 37 & CurRow + 29).Select But that that wouldn't work because CurCol is a numeric value not the A B C ... value that Range expects. Any idea? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select multiple adjacent cells of multiple cells without selecting | New Users to Excel | |||
Select multiple adjacent cells of multiple cells without selecting | Excel Worksheet Functions | |||
macro copy/paste data from multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
Date and time stamping multiple cells for multiple entries. | Excel Worksheet Functions | |||
make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions |