Recent content by StuartJones

We have a simple setup on one server where we had a software mirror. When we recieved a message that the mirror disk had failed, we replaced the hard drive and restarted. The original disk is now set as Disk 1 in the Disk Manager, and the new mirror disk is set as Disk 0. This is despite the...

i think the problem was because i did not complete the wizard properly. my colleague has given me a recorded macro of the entire process which now works. thanks for your help guys - sorry that i've been so dense

it's a chart that I created in the worksheet from the wizard.

same problem - i'm pretty sure I've tried it already, but I did it again and same '1004' error.

I still get the '1004' error with this code: Worksheets(1).Activate ActiveSheet.ChartObjects("Chart 3").Activate With ActiveChart .Type = xlLine .HasTitle = True .ChartTitle.Text = "Historical Data" With .SeriesCollection .Add Source = Worksheets(2).Range("C:C")...

I'm still getting a '1004' error message "Unable to set the HasTitle property of the Chart class'

actually - i just tried that, and it failed... ActiveSheet.ChartObjects("Chart 3").Activate With ActiveChart.Chart .Type = xlLine .HasTitle = True .ChartTitle.Text = "January Sales" numRows = Worksheets(2).Rows.Count With .SeriesCollection...

cheers Skip.

thanks. I just saw my mistake.... I had ActiveWorksheet, instead of ActiveSheet. But now the .HasTitle doesn't want to work.. :(

Geoff, I did that and the macro recorded was: ActiveSheet.ChartObjects("Chart 3").Activate I then put the following code in my vb script: Worksheets(1).Activate ActiveWorksheet.ChartObjects("Chart 3").Activate and now I'm getting an "object required" error on the second line instead...

I getting a "subscript out of range" error when i try and specify my chart as: ActiveWorkbook.Charts(1).Activate I only have one chart in the workbook, and cannot find any other way of referencing it. TIA, Stuart

Thanks Skip, As I said in my other question today, I'm not too well-up on VBA, so I'm kinda throwing things from the on-line help together and hoping it sticks :) Cheers for your help - I got the code working again.

Hi, I'm having a bit more trouble now. This code was working about an hour ago, and now it isn't. I didn't change anything (simply closed the workbook and then re-opened it). I keep getting errors on the Worksheets(2).Columns("A:A").Select command TIA - Stuart Private Sub...

Thanks, I'm afraid I don't know VBA that well, and the on-line hindrance isn't very good in Excel. Line Input worked - so thanks again.

Hi - I'm getting a "bad recordlength" error message when I use the GET statement to read from a csv file. Problem is, I don't know what the length of the line is until I read it. Any help would be appreciated. Stuart