Blplinkreset Error
Contents |
Forums Excel Questions Macro randomly stopped working? I have used this macro for
Macro Not Available In This Workbook Error
months....???? Results 1 to 7 of 7 Macro randomly stopped cannot run macro error in excel 2010 working? I have used this macro for months....????This is a discussion on Macro randomly stopped cannot run the macro excel 2013 working? I have used this macro for months....???? within the Excel Questions forums, part of the Question Forums category; Good Morning (well..not really) Below is
Dmonentry_net
a macro that I have been using very reliably for months now. Admittedly, I ... LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Switch to Threaded
Cannot Run The Macro Excel 2016
Mode Jun 20th, 2012,08:24 AM #1 MickFlanagen New Member Join Date Jan 2012 Posts 27 Macro randomly stopped working? I have used this macro for months....???? Good Morning (well..not really) Below is a macro that I have been using very reliably for months now. Admittedly, I am pretty new to writing macros, but I still don't understand why this macro worked yesterday, and won't work today. Here it is: Code: Application.ScreenUpdating = False Sheets("Bloomberg Data").Select Application.Run "BLPLinkReset" Range("A1").Select Workbooks.Open Filename:= _ "T:\usequty\Audit Reporting\T-Cross Reports\tcross.xls" Application.Run "BLPLinkReset" Application.Run "ConnectChartEvents" Application.Run "'New Template.xls'!DelCASHCONV" ActiveWindow.Close Sheets("bloomberg data").Select Application.Run "BLPLinkReset" Range("A1:P1").Select Selection.AutoFill Destination:=Range("A1:P1000"), Type:=xlFillDefault ******this is the line that is giving me trouble. Range("A1:P1000").Select Workbooks.Open Filename:= _ "T:\usequty\Audit Reporting\T-Cross Reports\tcross.xls" Application.Run "BLPLinkReset" Application.Run "ConnectChartEvents" ActiveWindow.Close Application.Run "BLPLinkReset" Range("A2").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("m2:O1000").NumberFormat = "hh:mm" Sheets("Report").Select Application.Run "BLPLinkReset" Range("A6:S6").Select Application.CutCopyMode = False Selection.AutoFil
360 games PC games unable to run macros in excel 2007 Windows games Windows phone games Entertainment All Entertainment
The Macro Is Stored In A File That Is Not Open.
Movies & TV Music Business & Education Business Students & educators cannot run the macro ddeopen Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://www.mrexcel.com/forum/excel-questions/641802-macro-randomly-stopped-working-i-have-used-macro-months.html Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/930076 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
dkassin03-01-2012, 02:02 PMI have macro where we enter between 1 and 4 characters http://www.vbaexpress.com/forum/archive/index.php/t-41189.html into a user form. The macro is working perfect except it returns an error when 4 characters are entered. The error reads as follows. Run-time error '-21473552571 (80020005)': Could not set the Value propert. Type mismatch. What does this mean? and How do I correct it? JKwan03-01-2012, 03:53 PMHow can anyone help you without seeing the code? wakdafak03-01-2012, 06:15 PMplease provide cannot run sample code tq dkassin03-02-2012, 06:32 AMPrivate Sub Okbutton_Click() 'Make Sheet1 Active Sheets(1).Activate 'Export Data to worksheet Cells(2, 5).Value = tbunder.Value Cells(2, 6).Value = cbunderxp.Value Cells(2, 3).Value = tvvolbeta.Value Cells(2, 4).Value = tbedge.Value Cells(2, 10).Value = tbus.Value Cells(2, 7).Value = tbuc.Value Cells(2, 18).Value = tbup.Value Cells(2, 34).Value = tbhedge.Value Cells(2, 35).Value = cbhxp.Value Cells(2, 41).Value = tbhc.Value Cells(2, 54).Value = tbhp.Value cannot run the 'Import data from work sheet tbhs.Value = Cells(2, 68).Value tbhcp.Value = Cells(2, 43).Value tbhpp.Value = Cells(2, 59).Value tbucp.Value = Cells(2, 14).Value tbupp.Value = Cells(2, 24).Value 'Add trade to positions sheet Sheets("Positions").Select Rows("4:4").Select Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove Range("A5:V5").Select Selection.AutoFill Destination:=Range("A4:V5"), Type:=xlFillDefault Range("A4:V5").Select End Sub Yellow text is where the debugger says the error occurs JKwan03-02-2012, 06:56 AMwhat you posted gives us very little to go on. can you post the workbook, strip out sensitive info if need to? dkassin03-02-2012, 06:57 AMThe problem seems to be occurring when the userform tries to import data from the workbook. dkassin03-02-2012, 07:01 AMPrivate Sub CommandButton3_Click() Unload Me End Sub Private Sub CommandButton4_Click() 'Sheet(1) Activate Sheets(1).Activate 'Import data from work sheet tbhs.Value = Cells(2, 68).Value tbhcp.Value = Cells(2, 43).Value tbhpp.Value = Cells(2, 59).Value tbucp.Value = Cells(2, 14).Value tbupp.Value = Cells(2, 24).Value End Sub Private Sub Entertradebutton_Click() 'Make Sheet1 Active Sheets(1).Activate 'ExportData to worksheet Cells(2, 36).Value = tbhs.Value Cells(2, 49).Value = tbhcp.Value Cells(2, 62).Value = tbhpp.Value Cells(2, 17).Value = tbucp.Value Cells(2, 27).Value = tbupp.Value 'hedge Sheets("2").Select Application.Run "BLPLinkReset" Columns("A:F").Select Range("F1").Activate Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove Range("G1:L3").Select Selection.cOPY Range("A1").Select Selection.PasteSpecial P