Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple For/Next
I'm trying to run the following code for each cell in range C2:Q16 ActiveCell.NumberFormat = "General" ActiveCell.Value = ActiveCell.Value I've put this as a loop, but would like to run it for rows C to without having to put in Range("c" & I)...Range("d" & I)....ect For I = 2 To 16 Range("C" & I).Select ActiveCell.NumberFormat = "General" ActiveCell.Value = ActiveCell.Value next I tried Range(& X & I).select, but it doesn't work. Where x = c to Q There is probably a way to select a range C2:Q16 and then convert. Ca anyone help? I'd also like to know how to use two "For" statements i combination, just for future reference. Thanks guy -- Ramthebuff ----------------------------------------------------------------------- Ramthebuffs's Profile: http://www.excelforum.com/member.php...fo&userid=1642 View this thread: http://www.excelforum.com/showthread.php?threadid=48295 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to link multiple columns to multiple worksheet totals / functi | Excel Worksheet Functions | |||
Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) | |||
Date and time stamping multiple cells for multiple entries. | Excel Worksheet Functions | |||
view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) |