Recent content by scottsek

I can't duplicate the error using a non-network destination (i.e. I used c:\ instead of \\). I also assumed that "IBM Passwords.xls" is either the workbook with the macro or another workbook that is open at the time. It worked OK. Maybe it's something to do with the network path or...

Here is an example where the column with the active cell is swapped with the column to the right: Sub SwapColumnRight() SwapRight ActiveCell End Sub Sub SwapRight(rngActiveCell As Range) Dim rngActiveColumn As Range 'gets entire column Set rngOriginalColumn =...

I gave you a couple of problems in your previous thread on this: thread707-442984 Hope it helps. Scott

I think the problem is that you have the autocorrect "Replace text as you type" option on and there is an entry in the autocorrect for &/and so that as soon as you type & it replaces it with and. Go to Tools/AutoCorrect Options and either uncheck the "Replace Text As You...

Where is this code, i.e. in what event have you put it? I'm using XP, to answer one of your questions. Scott

Excel has a feature built-in that will allow you send the workbook, which I don't think you want. You just want to send a "note" that it's been saved. If so, you'll have to use VBA. If you use VBA, there's a pseudo-cheating way that uses the Excel send feature to send a new (and...

... and I don't see where NumToMove (from the header) is anywhere else in your code, maybe you snipped it when you posted. Scott

I know you don't want anything difficult, but if you just put cdate around the textbox1.text like this let sheets("sheet1").cells(1,1) = CDate(textbox1.text) it should work. I've tested it with UK settings and it works on my computer. If you still have trouble, please re-post...

I actually use another method to get the last used row: I'll assume column A also To get the cell itself (which is how I usually use it): Set newDataRow = Range("a1").EntireColumn.Cells(Rows.Count).End(xlUp).Offset(1, 0) but if you want the row just add .Row to the end: datarow =...

One problem is that you're using PHChartObj.SeriesCollection instead of PHChart.SeriesCollection. SeriesCollection is a collection of Chart, not ChartObject. HTH, Scott

Can you post an example of the code? If it's approximately the same, then you could probably use a class module with the keyword WithEvents to create a "typical" button with your special code in the Click event. Once I see some code, I think I'll be able to explain better (with code...