View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Oblivious Oblivious is offline
external usenet poster
 
Posts: 1
Default Help Please: Syntax Problem


Hello everyone,

I'm quite new with VB; I've had experience with other programmin
languages though.

For this line:

Dim UniqueCount As Integer
UniqueCount = "=ROWS(R5C1:R" & LastRow2 & "C1)"

I know that I cannot automatically assign UniqueCount the value of tha
formula. How would I format the line such that I can indeed assig
UniqueCount the row value of that line? Thank you in advance

--
Obliviou
-----------------------------------------------------------------------
Oblivious's Profile: http://www.excelforum.com/member.php...fo&userid=3504
View this thread: http://www.excelforum.com/showthread.php?threadid=54787