Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Range Values with VBA
I really haven't used VBA in Excel before, but what I'm trying to do i loop through a range of cells and determine the string value an increment 2 counters depending on the value of the strings and the display the value in a cell in the EXCEL spreadsheet. I have NO idea on how to do this except that I probably need to us VBA. I am a .Net/C# programmer so that wil give you an idea of m background.. Thanks for your help! Dou -- drdexter3 ----------------------------------------------------------------------- drdexter33's Profile: http://www.excelforum.com/member.php...fo&userid=3620 View this thread: http://www.excelforum.com/showthread.php?threadid=55990 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Range Values with VBA
For Each cell In Selection Select Case cell.Value Case "abc": cntr1 = cntr1 + 1 Case "xyz": cntr2 = cntr2+1 Case Else: MsgBox "oops" End Select Next cell -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "drdexter33" wrote in message ... I really haven't used VBA in Excel before, but what I'm trying to do is loop through a range of cells and determine the string value and increment 2 counters depending on the value of the strings and then display the value in a cell in the EXCEL spreadsheet. I have NO idea on how to do this except that I probably need to use VBA. I am a .Net/C# programmer so that wil give you an idea of my background.. Thanks for your help! Doug -- drdexter33 ------------------------------------------------------------------------ drdexter33's Profile: http://www.excelforum.com/member.php...o&userid=36203 View this thread: http://www.excelforum.com/showthread...hreadid=559903 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for named cell/range using cell values | Excel Worksheet Functions | |||
formula for named cell/range based on cell values | Excel Programming | |||
Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) | |||
Search/Filter to find values in another range based on two cell values | Excel Programming |