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...
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...
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...
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
E0H01 (Repeat here)
E0H54 (Repeat here)
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.
I've been successfully able to delete all excel tabs where there are 0 rows of data in it using the code below:
Dim ws As Worksheet
Application.DisplayAlerts = False
For Each ws In ActiveWorkbook.Worksheets
If Application.CountA(ws.Cells) = 0 Then ws.Delete