View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
 
Posts: 1,045
Default Problems with setting .Values with vba

On Fri, 18 May 2012 18:06:55 +0000, confusedXLuser wrote:

If I can't figure out how to use split ranges on a Line chart in the
next couple days, I'll go into 'workaround' mode and try a hidden sheet
with contiguous ranges - copying my split-sheet data to it. Not my
preference, but much less complex from a vba coding perspective. I've
already wasted 2 weeks trying every web-based idea I could find.

Thanks again for your quick response, and I close begging your
forgiveness for wasting your time on such a dumb mistake.


Glad to help. And I've made plenty of mistakes which, when uncovered, seemed pretty dumb.