msexcel

I have a macro/vba codes written, which is running smoothly although probably slower than the usual. The problem is >It crashes when i saveas the file with a different name and open a new empty workbook. I ran the macro line by line/ step by step and it is when saving the file that it...

I need to validate domain name if it is valid or not, excel formulas or VBA would help

Hello Dear friends. I have a macro which brings data from an external application using a loop. Think that external application has two olumns which is vehicle, and vehicle delivery date. My excel has the same two columns. So it brings vehicle delivery date information from the external...

Hello Everyone. In the following table I gave some example texts. For the "Correction Work" tasks, I need to find the number of the works which is written the same tasks without "Correction Work" So for your better understanding I wrote manually what result should formula give us in the column...

The attached workbook has data in different worksheets that need to be aligned to correspond to each contiguous rows from one sheet to another to enable my formula to make accurate analyses. I need each name on each worksheet in the workbook to be in the same corresponding column and rows along...

Score Range 5 -30% 4 -10% to -29% 3 +10% to -9% 2 +11% to +29% 1 >30%;High Hello, I need to test the above mentioned criteria for a set of values(in percent). Could...

Please help me that how can we repeat column B names (vamsi and suresh) until cell value = EOH12 (column A). A column I B column E0H11 vamsi E0H24 suresh E0H01 (Repeat here) E0H54 (Repeat here) EOH12 (Repeat...

I have an always open MsExcel file that updates automatically I would need a macro or VB command that publishes an area of this MsExcel sheet on a WEB page (with USER ID and PASSWORD to access) with an interval of 1 minute. Thank you for your precious help. Roberto Giussani

Hi, I've been successfully able to delete all excel tabs where there are 0 rows of data in it using the code below: Sub DelMT() Dim ws As Worksheet Application.DisplayAlerts = False For Each ws In ActiveWorkbook.Worksheets If Application.CountA(ws.Cells) = 0 Then ws.Delete Next ws...

Hi, 1. I need to find a word or text or formula (inside a cell) 2. To show or hide a range of rows/columns. Thanks in advance, Sridhar.S

Hello, I have a formatting Macro I would like to be able to trigger automatically as soon as some numerical values populate the to be formatted columns. Is it possible? How can I do ? Emile