vba error

This code give me a "Type Mismatch" error, but I can't figure out the issue. Can anyone see what is mismatched? All this is meant to do is to break all links to other workbooks. Sub BreakLinks() On Error GoTo ErrorHandler Dim vLinks As Variant Dim lLink As Long vLinks =...

I've been reading like posts on mrexcel.com for an hour - but still cannot fix my problem. I have what I think should be a pretty basic code to copy visible cells in one sheet, then paste values in the next sheet. I continue to get a run-time 1004 "PasteSpecial method of Range class failed"...

Hi Folks, This is going to be a lo-o-ng post, so thanks in advance to those who power through it and reply to this thread. I have a mature (been in use for 3 years) spreadsheet that was created w/ Excel 2007 and saved as an *.xls file as most end users still run Excel 2003. This...

Hi All, I'm hoping somebody on here can help me with this as Google has not been very useful at all in trying to solve this. I'm currently running Windows 7 (Ultimate, 32-bit) along with MS Office 2007 Enterprise and I'm trying to use the ListView functions or the DTPicker. I've enabled MS...

Hi, I am receiving the above error when trying to process this line of code: FinalRow = 20 Cells(4, 18).Resize(FinalRow - 3, 1).Formula = _...

Const CtyCount As String = 2 Const CtyName As String = 10 Const CapIQID As String = 12 Const BusUnit As String = 13 Const GovnDoc As String = 50 Const LegStat As String = 51 Const LegStatDate As String = 52 Const LegDocOwner As String = 53 Const LegContactName As String = 54 Const LegContactNum...

I used the recorder in Excel 07 but when someone runs it in 03 this is failing. Can someone please help. With Selection.Font .Name = "Arial" .FontStyle = "Bold" .Size = 10...

Need some help with this VBA code, I can't see why it doesn't work. Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Select Case Target.Address Case "$E$2" ActiveSheet.ChartObjects("Chart 2").Chart.Axes(xlCategory) _ .MaximumScale =...

I hope I can explain the problem well enough that someone can help because I cannot forward the file that is causing the error -- it's nearly 25MB. There's quite an extensive relational database involving several sheets and a VBA userform interface and code. All has been running well for the...