View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mudraker[_382_] mudraker[_382_] is offline
external usenet poster
 
Posts: 1
Default Help w/ .Range(passing searched cells) I can't do it


osman

You have included your variable names within "" This causes Excel to
see them as a continuos string

try

ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range(Fst & ":" &
Lst), PlotBy:=xlColumns


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=539819