| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How to set variable to cell value in excel macro
You are welcome.
"most xlent" wrote: Way to go Kleev! Your suggestion did the trick. Thanks alot! "Kleev" wrote: You could do something like this: Dim ws As Worksheet Dim i As Integer Dim x As Integer Set ws = ThisWorkbook.Worksheets("sheet2") i = ws.Range("c1").Value x = 1 Do While x < i ws.Cells(x, 4).Value = x + i x = x + 1 Loop "most xlent" wrote: How do I perform a "do loop" using a cell value as criteria? (i.e.-do while x < value($c$1). Thanks for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
| How do I set a macro to print variable number of pages in excel? | Excel Discussion (Misc queries) | |||
| How can I edit cell contents with a macro in Excel? | Excel Discussion (Misc queries) | |||
| How can I edit cell contents with a macro in Excel? | Excel Discussion (Misc queries) | |||
| How to save Excel macro using name contained in cell? | Excel Worksheet Functions | |||
Hybrid Mode
