Run time error 1004Step backwards and use col not i. Also, can wrap in a With. Option Explicit Sub DeleteBlank() Dim wb As Workbook Set wb = ActiveWorkbook Dim col As Long Dim ws As Worksheet Set ws = wb.Worksheets("Sheet1") With ws For col = 4 To 1 Step -1 If WorksheetFunction.CountA(.Columns(col)) = 0 Then .Columns(col).Delete End If Next col End With End SubGet emails out to your customers reliably, and without hassle, every single time. Use vbMAPI alongside Microsoft Outlook to add professional emailing capabilities to your projects.What Is Runtime Error 1004 In VBA Excel? Excel error 1004 is one such annoying runtime error that mainly encounters while working with the Excel file. Or while trying to generate a Macro in Excel document and as a result, you are unable to do anything in your workbook.Click on menu File -> New -> Project... or you can press the hot key Ctrl + Shift + N (please see Figure 2). From New Project dialog box select -> Visual C# -> Windows. From Templates select -> Windows Application. Please give the name to the application; I've called the project as "WinDebug101".A forum for all things Excel. Ask a question and get support for our courses.Step backwards and use col not i. Also, can wrap in a With. Option Explicit Sub DeleteBlank() Dim wb As Workbook Set wb = ActiveWorkbook Dim col As Long Dim ws As Worksheet Set ws = wb.Worksheets("Sheet1") With ws For col = 4 To 1 Step -1 If WorksheetFunction.CountA(.Columns(col)) = 0 Then .Columns(col).Delete End If Next col End With End Sub Answer:. Make sure that you have created your folder structure into which the file will be saved. You can code your solution to check that the folders have been created and if not, it can created them. I have had a similar problem before. Check that the folder path used in the following code exists: If it does not exist, create it and try again.Oracle Project Planning and Control - Version 11.5.10.2 and later: R11 R12 Run-time Error '1004' ': Method 'VBProject' of object '_Workbook' failed Opening WebADI inPrivate Sub UserForm_Initialize() 'Puts the user form in the middle of the Excel screen when opened. Me.StartupPosition = 0 Me.Top = (Application.Height / 2) - (Me.Height / 2) Me.Left = (Application.Width / 2) - (Me.Width / 2) Dim ws As Worksheet Set ws = Sheets("Vendors") If Sheets("Sheet1").Cells(5, 3) = "" Then 'C5 is where company/vendor name is MsgBox "Please select ...The issue here ended up being with authentication to the Office application, in this case Excel. To resolve the issue I performed the following simple steps: Open Excel. Click the "account" link. At the top, click the "sign out" link. Close Excel. Go back to your SharePoint list and click the "Export to Excel" button.The Values field is the one that appears when you have more than one data field. Its location in the Rows or Columns area of the pivot table dialogs controls the grouping of those data fields. In the following example, I've grouped the data area by data fields within years. In other words, the two summing data fields appear side-by-side for ...portable air conditioner walmartCompare Search ( Please select at least 2 keywords ). Most Searched Keywords. Menus for low fat diet 1iSunshare is dedicated to providing the best service for Windows, Mac, Android users who are in demand for password recovery and data recovery.Run-time error 1004 is a Microsoft Visual Basic error code that has been known to impact users of Microsoft Excel. Although the problem is most…Compare Search ( Please select at least 2 keywords ). Most Searched Keywords. Menus for low fat diet 1 In Excel 2003, go to "Tools" > "Macro" > "Security" and select the "Trusted Sources" tab. Check the box next to "Trust access to Visual Basic Project". (Note: The box for "Trust all installed add-ins and templates" should also be checked.) In Excel 2007, use the following navigation: Click on the Office button in the ...Download for Win Recovery Rate 99.7%. Download for Mac Trustpilot Rating 4.4 Trustpilot Rating 4.4Run-time error 1004 is an error code pertaining to Microsoft Visual Basic that has been known to affect Microsoft Excel users. The error is known to be most prevalent on Excel 2003 and Excel 2007, although no version of Microsoft's popular worksheet application for computers is safe from the menace that is Run-time error 1004.Step backwards and use col not i. Also, can wrap in a With. Option Explicit Sub DeleteBlank() Dim wb As Workbook Set wb = ActiveWorkbook Dim col As Long Dim ws As Worksheet Set ws = wb.Worksheets("Sheet1") With ws For col = 4 To 1 Step -1 If WorksheetFunction.CountA(.Columns(col)) = 0 Then .Columns(col).Delete End If Next col End With End Sub Download for Win Recovery Rate 99.7%. Download for Mac Trustpilot Rating 4.4 Trustpilot Rating 4.4horse racing entriesThis will install the VC Redist 11.0 framework packages to your ExtensionSDKs folder. For your application to reference the VC runtime dlls, you need to manually install the framework packages using the add-appxpackage cmdlet.vba - Error:- Run-time error '1004' - Stack OverflowHow to Fix VBA Run-Time Error '1004' - Excel VBA Tutorial.Issues addressed in this tutorial:vba runtime error 1004vba runtime errorvba runtime error 424vba r...Step backwards and use col not i. Also, can wrap in a With. Option Explicit Sub DeleteBlank() Dim wb As Workbook Set wb = ActiveWorkbook Dim col As Long Dim ws As Worksheet Set ws = wb.Worksheets("Sheet1") With ws For col = 4 To 1 Step -1 If WorksheetFunction.CountA(.Columns(col)) = 0 Then .Columns(col).Delete End If Next col End With End Sub Run-time error '1004' is a common error while writing VBA Code.This tutorial explains, how to fix Application-defined or Object-defined error with simple exa...Jun 15, 2018 · "Run-Time Error '1004': Method 'Open' of object 'Workbooks' failed" when trying to use TM1 9.5 Perspectives addin and Excel 2007 VBA:ランタイムの取得1004:セルの使用時にオブジェクト '_Worksheet'のメソッド 'Range'が失敗しました Get Workbook Name and Worksheet Name from a Range in Excel-VBA Range(cells(x、y))。Sub copydatabis() Dim Nom As Variant Dim NomStk(), SerieDate() 'Suppression des noms des plages For Each Nom In ActiveWorkbook.Names If Nom.Name = "Stocks" Or Nom.Name = "DateDeb" Or Nom.Name = "DateFin" Then Nom.Delete End If Next 'Réinitialisation des plages Nom ActiveWorkbook.Names.Add Name:="Stocks", RefersToR1C1:="=offset('Sheet1'!R4C1,1,,counta('Sheet1'!C1)-3,1)" ActiveWorkbook.Names ...In the menu bar, select "File"> "Options [Excel]"> "Trust Center"> "Trust Center Settings"> "Macro Settings". Activate the option button "Deactivate all macros with notification" in the upper area. In the lower area, check the box next to "Trust access to VBA project object model". Click "OK" and "OK" to save ...The issue here ended up being with authentication to the Office application, in this case Excel. To resolve the issue I performed the following simple steps: Open Excel. Click the "account" link. At the top, click the "sign out" link. Close Excel. Go back to your SharePoint list and click the "Export to Excel" button.VBA Paste special linked picture = run-time error '1004'Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.Dec 23, 2019 · I was also looking for the cause of this error, and then remembered I was working on a version of my spreadsheet that had been recovered. Once I manually saved the recovered file and reopened it there was no problem with the vba code to save the workbook. xfinity net emailSep 18, 2020 run-time error '1004' vba S Sarche New Member Joined May 17, 2016 Messages 44 Sep 18, 2020 #1 I wrote a VBA code that was working until a few days ago now I am getting an error message that is can't do that to a merged cell when trying to copy and paste. However, there are no merged cells in the section that is being copied and pasted.Harvard community, log in to see your tickets and services, and access chat support. Log InStep 1: Open MS Excel and go to the File tab. Now, Click on Options in the menu. Step 2: In the Excel Options window, click on Trust Center on the left side of the pane. On the right side, click on the Trust Center Settings. Step 3: In the Trust Center window, click on the Macro Settings options on the left.当按f5键,就报:运行时错误1004。经老师指点,单击文件――选项――信任中心――打开"信任中心"对话框,宏设置――勾选"信任对vba工程对象模型的访问"。再次运行,就不会出现运行时错误1004提示。 后来在微软官方也看到了此消息。In order to sort columns in a table with VBA, you have to create one. This is the table we are going to use. After you created the table, go to Design >> Properties and change the name of the table. Contents. 1 Sort table ascending and descending using ListObject. 2 Sort table by two and more columns.Today we got a ticket from the business user that Excel is throwing error: "Run-time 1004 error: Method 'Sheets' of object '_Global' failed.". I could not find an answer even after searching online for hours.In the menu bar, select "File"> "Options [Excel]"> "Trust Center"> "Trust Center Settings"> "Macro Settings". Activate the option button "Deactivate all macros with notification" in the upper area. In the lower area, check the box next to "Trust access to VBA project object model". Click "OK" and "OK" to save ...The reason for the failure is that you don't have a worksheet by the name of "C2". Therefore you can't select it. "C1" looks like a cell address.Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.Mar 10, 2022 · For this follow the below steps: Launch Microsoft Excel on your computer. Click on Office symbol and click" Save as". In the "Save as type" drop-down, select "Excel template" and click "Save". Find resources for Excel development, including code samples, events, blog posts, and more.Click on menu File -> New -> Project... or you can press the hot key Ctrl + Shift + N (please see Figure 2). From New Project dialog box select -> Visual C# -> Windows. From Templates select -> Windows Application. Please give the name to the application; I've called the project as "WinDebug101".david dobrik puzzleexcel - Pasting after ClearContents in VBA - Stack Overflow. Excel Details: Copy Excel Table Column (ListColumn.Range)In your code, when you did the ClearContents, you actually removed the copied range from the clipboard.As Tim Williams suggested in the comments, you had to move the ClearContents line before the Selection.Copy line and appropriately rearrange the Select lines.; Feb 15, 2021 · Menu HomePosts Popular PostsAttributionsrubberduckvba.com WorksheetFunction and Errors Posted February 15, 2021February 15, 2021 Rubberduck VBA Using Excel worksheet functions taps into the native calculation engine using Excel’s very own MATCH function instead writing lookup... Click the "Set as Default Chart" button, and then click Cancel. This sets the default chart type without actually creating a chart. In Excel 2013 and 2016: Select a cells that contains a number. Click the Insert tab in the ribbon. In the Charts section, click the "See All Charts" button, which is the tiny arrow in the bottom-right corner.Mar 10, 2022 · For this follow the below steps: Launch Microsoft Excel on your computer. Click on Office symbol and click" Save as". In the "Save as type" drop-down, select "Excel template" and click "Save". CODE Public Function xlCopyWorksheets(sFileLoc As String, sUCI As String, sS_WrkBk As String, sT_WrkBk As String, sS_ShtNm As String, sT_ShtNm As String) Dim wrkbk As Workbook Dim wrksht As Worksheet Dim sFileType As String 'Open destination workbook sFileType = "xls" Call xlOpen(sFileLoc, sUCI, sT_WrkBk, sT_ShtNm, sFileType) 'Added activate statement goXl.Workbooks(sS_WrkBk).Activate 'Sheets ...In the menu bar, select "File"> "Options [Excel]"> "Trust Center"> "Trust Center Settings"> "Macro Settings". Activate the option button "Deactivate all macros with notification" in the upper area. In the lower area, check the box next to "Trust access to VBA project object model". Click "OK" and "OK" to save ...For each group, we'll explore some examples, and then discuss how you might investigate and resolve them. 1. Syntax errors - A specific line of code is not written correctly. 2. Compile errors - Issues that happen when putting together lines of code, though the individual lines of code seem to make sense. 3.another word for very goodSo it must have probably been an issue with the xlwings VBA module that you were using. Need to check the template if something has gone wrong there.1 Answer1. Show activity on this post. as you're counting nonblank cells in column B, and using it in the VLOOKUP function. There is more at fault in your code. myRange is not declared as a range but as a variant! A declaration like Dim a,b,c as range only defines c as a range and a and b as variants. The correct syntax would be Dim a as range ...1) Original steps: These are the steps that performed to build the import format. Development Manager >> Setup >> Setup Workbench. Select the class that should have the Import Format you are creating (we have create a specific ICC called "Utility Class Import Format" ) Click on Import Format. Click on Create button.I have not noticed a difference, as long as you do complete ranges at once. I think part of your problem may be that the code is actually affecting millions of cells when you use the Column.value = column.Value version. You also use this line, which helps: Application.CutCopyMode = False.In order to sort columns in a table with VBA, you have to create one. This is the table we are going to use. After you created the table, go to Design >> Properties and change the name of the table. Contents. 1 Sort table ascending and descending using ListObject. 2 Sort table by two and more columns.Run-time error '1004' - Programmatic access to Visual Basic Project is not trusted (Mac) Run-time error '1004' - Programmatic access to Visual Basic Project is not trusted (Mac) This error appears on Office 2016 or greater and Office 365 on the Mac version. This error is due to the addition of a security option in the Office options by Microsoft.The Internet has many places to ask questions about anything imaginable and find past answers on almost everything.If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).How to Fix Excel cannot access read-only Documents [2021] One of Excel errors is "Cannot access read-only Document. This problem can be fixed easily and quickly by the best Excel file repair tool.For each group, we'll explore some examples, and then discuss how you might investigate and resolve them. 1. Syntax errors - A specific line of code is not written correctly. 2. Compile errors - Issues that happen when putting together lines of code, though the individual lines of code seem to make sense. 3.Example #2. In this example, we will consider that mathematical division which gives infinite result, but in coding, it will #DIV/0 result. To demonstrate this, we will consider one more integer Z along with X and Y in a subcategory, as shown below.Mahmoud is a highly experienced VBA coder with 8 years of experience in Excel automation. He was a full time Excel Automation Specialist for a US government Medicare & Medicaid contractor for 4 years.If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).Yeah, I see it now. This seems to be another undiscovered bug of Google Coding Platform that is generating false Runtime Errors. This article is dedicated to Java.Hello I am trying to create a macro to take data from a worksheet and create and save separate workbooks based upon unique values in a specific column. I found some code which I managed to modify, (with help), and it gets to the point of creating the first workbook but it hangs on the SaveAs. I have tried researching file formats, etc., and changing the location where it saves but I am still ...Cách sửa lỗi Runtime Error 1004 trong Microsoft Excel: Microsoft Excel là một bảng tính phổ biến nhất được sử dụng trên toàn cầu cho cả ...1) If Program is the sheet name, enclose it in quotes: Set xlSheet = xlBook.Worksheets("Program") 2) Specify the sheet that Range belongs to: Set rng = xlSheet.Range("A2:A50") Join Date 04-23-2009 Location Matrouh, Egypt MS-Off Ver Excel 2013 Posts 6,829vba - Error:- Run-time error '1004' - Stack Overflow3 day egg fastThe reason for the failure is that you don't have a worksheet by the name of "C2". Therefore you can't select it. "C1" looks like a cell address.A Computer Science portal for geeks. It contains well written, well thought and well explained computer science and programming articles, quizzes and practice/competitive programming/company interview Questions.Example #2. In this example, we will consider that mathematical division which gives infinite result, but in coding, it will #DIV/0 result. To demonstrate this, we will consider one more integer Z along with X and Y in a subcategory, as shown below.Cause. This behavior can occur when both the following conditions are true: You are using a Visual Basic for Applications macro to save a worksheet.VBA runtime error 1004 with tutorial and examples on HTML, CSS, JavaScript, XHTML, Java, .Net, PHP, C, C++, Python, JSP, Spring, Bootstrap, jQuery, Interview ...Hello I am writing a vba macro for my custom need. Below is a code line in this macro: Worksheets(strt_stmp).Range(Cells(rw1, cl1), Cells(rw1 + 8, cl1)).Value = "" (strt_stmp, rw1, cl1 are variables2) Replacing the new library with the old version may/will break the new software in ways that you can not anticipate. 3) Anyone using your "application" on a PROPERLY installed version of the software will run into the very same issue that you have done an end-run around and they will "thank you" many times over. Private Sub UserForm_Initialize() 'Puts the user form in the middle of the Excel screen when opened. Me.StartupPosition = 0 Me.Top = (Application.Height / 2) - (Me.Height / 2) Me.Left = (Application.Width / 2) - (Me.Width / 2) Dim ws As Worksheet Set ws = Sheets("Vendors") If Sheets("Sheet1").Cells(5, 3) = "" Then 'C5 is where company/vendor name is MsgBox "Please select ...Cách sửa lỗi Runtime Error 1004 trong Microsoft Excel: Microsoft Excel là một bảng tính phổ biến nhất được sử dụng trên toàn cầu cho cả ...Mahmoud is a highly experienced VBA coder with 8 years of experience in Excel automation. He was a full time Excel Automation Specialist for a US government Medicare & Medicaid contractor for 4 years.By the way, the With isn't really needed in that code. You rarely if ever need to use Activate/Select in Excel VBA and using With to qualify a singe cell/range is perhaps a bit much.I have not noticed a difference, as long as you do complete ranges at once. I think part of your problem may be that the code is actually affecting millions of cells when you use the Column.value = column.Value version. You also use this line, which helps: Application.CutCopyMode = False.Recorded macro aren't very robust. I always edit recorded macros eliminating the unecessary items and replace SELECTION with absolute cell references.nike mens flex experience run 10 running shoes reviewsCODE Public Function xlCopyWorksheets(sFileLoc As String, sUCI As String, sS_WrkBk As String, sT_WrkBk As String, sS_ShtNm As String, sT_ShtNm As String) Dim wrkbk As Workbook Dim wrksht As Worksheet Dim sFileType As String 'Open destination workbook sFileType = "xls" Call xlOpen(sFileLoc, sUCI, sT_WrkBk, sT_ShtNm, sFileType) 'Added activate statement goXl.Workbooks(sS_WrkBk).Activate 'Sheets ...The Internet has many places to ask questions about anything imaginable and find past answers on almost everything. Mar 10, 2022 · For this follow the below steps: Launch Microsoft Excel on your computer. Click on Office symbol and click" Save as". In the "Save as type" drop-down, select "Excel template" and click "Save". Run-time error 1004 is a Microsoft Visual Basic error code that has been known to impact users of Microsoft Excel. Although the problem is most…Do strAnswer = InputBox ("Please input the name of the workbook that contains the Wage data") intFlag = MsgBox ("Press OK if this is the correct name - " & strAnswer, vbOKCancel) Loop Until intFlag = 1 Workbooks (strAnswer).Activate Set WBWage = ActiveWorkbook Set WSWage = Worksheets ("Sheet1") ' Get last row of wage data to check.Click on menu File -> New -> Project... or you can press the hot key Ctrl + Shift + N (please see Figure 2). From New Project dialog box select -> Visual C# -> Windows. From Templates select -> Windows Application. Please give the name to the application; I've called the project as "WinDebug101".Hi everybody, I need some help regarding my VBA homework, the task is to write a subroutine that copies and paste a range of returns from the table to an empty one while replacing the cell with the highest and lowest return with "winner" and "loser".Get emails out to your customers reliably, and without hassle, every single time. Use vbMAPI alongside Microsoft Outlook to add professional emailing capabilities to your projects.The Internet has many places to ask questions about anything imaginable and find past answers on almost everything. Feb 15, 2021 · Menu HomePosts Popular PostsAttributionsrubberduckvba.com WorksheetFunction and Errors Posted February 15, 2021February 15, 2021 Rubberduck VBA Using Excel worksheet functions taps into the native calculation engine using Excel’s very own MATCH function instead writing lookup... Oracle Project Planning and Control - Version 11.5.10.2 and later: R11 R12 Run-time Error '1004' ': Method 'VBProject' of object '_Workbook' failed Opening WebADI inford front royalVBA runtime error 1004 with tutorial and examples on HTML, CSS, JavaScript, XHTML, Java, .Net, PHP, C, C++, Python, JSP, Spring, Bootstrap, jQuery, Interview ...To fix Excel "document not saved" error, try the following steps in order: Save your file as a different Excel file type. Available file types depends on your version of excel. Click File -> Save As -> Browse. To save as a different file type, click the drop-down beside Save as type. For a full list of supported Excel file formats click ...Run-time error '1004': Application or object-defined error Cause This behavior occurs when the Excel chart contains more legend entries than there is space available to display the legend entries on the Excel chart. When this behavior occurs, Microsoft Excel may truncate the legend entries.Sage VIP Run-time Error 1004 General ODBC Error Sage VIP Special Solutions Knowledge Base Page 1 of 1 Error: Run-time Error 1004 General ODBC Errorexcel - Pasting after ClearContents in VBA - Stack Overflow. Excel Details: Copy Excel Table Column (ListColumn.Range)In your code, when you did the ClearContents, you actually removed the copied range from the clipboard.As Tim Williams suggested in the comments, you had to move the ClearContents line before the Selection.Copy line and appropriately rearrange the Select lines.; I can't even get past the first autofilter. In other files, where a macro is using autofilter as well, it worked fine before. From this point forward, I can't get any autofilter code to work.Feb 15, 2021 · Menu HomePosts Popular PostsAttributionsrubberduckvba.com WorksheetFunction and Errors Posted February 15, 2021February 15, 2021 Rubberduck VBA Using Excel worksheet functions taps into the native calculation engine using Excel’s very own MATCH function instead writing lookup... This will install the VC Redist 11.0 framework packages to your ExtensionSDKs folder. For your application to reference the VC runtime dlls, you need to manually install the framework packages using the add-appxpackage cmdlet.If you experience the above error message when processing a Journal Upload to Dimensions whilst using the Journal Upload Template the below will assist you in ...Run-time error 1004 is an error code pertaining to Microsoft Visual Basic that has been known to affect Microsoft Excel users. The error is known to be most prevalent on Excel 2003 and Excel 2007, although no version of Microsoft's popular worksheet application for computers is safe from the menace that is Run-time error 1004.Application defined or object defined error 2015-01-22 · Run-time Error 32809: Application-defined Or Object-defined Error Hi All I am getting the above error ...我的IT知识库-VBA+Displaying+the+standard+run+time+error+handler搜索结果craigslist peoria azApr 06, 2022 · Application defined or object defined error 2015-01-22 · Run-time Error 32809: Application-defined Or Object-defined Error Hi All I am getting the above error ... VBA:ランタイムの取得1004:セルの使用時にオブジェクト '_Worksheet'のメソッド 'Range'が失敗しました Get Workbook Name and Worksheet Name from a Range in Excel-VBA Range(cells(x、y))。Interesting. Would you do me a favor and test one thing? Replace ThisWorkbook.Sheets("Input").Range("A1").Select with shtInputSheetCodeName.Range("A1").Select and try it again. Of course you'll have to exchange the CodeName for the real one ?ThisWorkbook.Sheets("Input").CodeName Another thing would be to Activate the sheet before .Selecting anything on the sheet.Feb 15, 2021 · Menu HomePosts Popular PostsAttributionsrubberduckvba.com WorksheetFunction and Errors Posted February 15, 2021February 15, 2021 Rubberduck VBA Using Excel worksheet functions taps into the native calculation engine using Excel’s very own MATCH function instead writing lookup... Tham gia 18/3/08 Bài viết 8,168 Được thích 15,506 Giới tính Nam Nghề nghiệp Làm ruộng.Dec 23, 2019 · I was also looking for the cause of this error, and then remembered I was working on a version of my spreadsheet that had been recovered. Once I manually saved the recovered file and reopened it there was no problem with the vba code to save the workbook. this is good info, all in one place, thank you! regarding your line numbers in the section above - i agree it is too hard to manually type line numbers, so i am looking for a tool as you suggest. do you recommend a tool?Step 1: Open MS Excel and go to the File tab. Now, Click on Options in the menu. Step 2: In the Excel Options window, click on Trust Center on the left side of the pane. On the right side, click on the Trust Center Settings. Step 3: In the Trust Center window, click on the Macro Settings options on the left.Which of the following is a run-time error? Attempting to divide by 0. Python cannot reliably tell if you are trying to divide by 0 until it is executing your program (e.g., you might be asking the user for a value and then dividing by that value—you cannot know what value the user will enter before you run the program).I was also looking for the cause of this error, and then remembered I was working on a version of my spreadsheet that had been recovered. Once I manually saved the recovered file and reopened it there was no problem with the vba code to save the workbook.To fix Excel "document not saved" error, try the following steps in order: Save your file as a different Excel file type. Available file types depends on your version of excel. Click File -> Save As -> Browse. To save as a different file type, click the drop-down beside Save as type. For a full list of supported Excel file formats click ...Personally, I'd avoid merging cells in worksheets. To get round this, perhaps you could use... Code: Range ("A1").EntireColumn.SpecialCells (xlCellTypeBlanks).Select Selection.EntireRow.Delete. But, if possible do not use merged cells to avoid unnecessary pain and suffering .key cap sets -fc