Thread: Select Case Syntax
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dana DeLouis[_3_] Dana DeLouis[_3_] is offline
external usenet poster
  
Posts: 690
Default Select Case Syntax
On 1/17/2010 11:01 AM, Dana DeLouis wrote:
Run "InvCol_" & fx, 3, 4

OOps. Don't know how it was changed to fx.
Anyway...

x = (vNum Mod 7) + 1

If x < 3 Then
Run "InvCol_" & x, vName, vNum
End If


= = = = = = =
HTH :)
Dana DeLouis
Reply With QuoteReply With Quote