excel macro vba

Hi all, am new to excel macro VB, I have a requirement , where i have the below data: <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> Number Value Number Value Difference <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>...

This is the code i have worked with. It is showing the error 1004 that the copy area and paste area are not in the same size. Please help me with the issue? Sheets("ESTemplate").Activate Sheets("ESTemplate").Columns("A:B").Select Selection.Copy Sheets("Effort_Summary").Activate For j = 2 To...

I want this macro to run after every 3 seconds so that each time i move a selected shape among many shapes its color should change. But this code only works once... It doesn't repeat or doesn't change the color of next shape i select and move to particular position. Public RunWhen As Double...

Dear all, I am very new to VBA. I have a requirement where I need to hide the columns based on the cell values. For Example, Consider J19, if this is empty then the columns from J to CC should be hidden. Then if K19 is empty, it should hide the columns from K to cc. Likewise, it should check...

Hello. Putting it in simple terms: I am looking for a code that puts the text from cell c3 into a range of cells from c5:c75. For example in range(c5:c75), if the cells c5 and c6 already have text, I would want to fill the cell c7 with my text. Another example is: if cells c5 and c7 have text...

I have a module that is working but when it ends, instead of staying on the spreadsheet, it goes back to the VB code, what am I doing wrong below: Sub UserInput() Dim iReply As Integer Dim Response As Variant Dim iNum As Integer ActiveSheet.Unprotect "XXXXX" iReply = MsgBox(Prompt:="Do...

I have a macro I need to convert to VBA. It is in a XLM file that ref's a DLL... it sends a value in a spreadsheet to a device via DDE. It uses the A and B column - B2 has a number in it.. A has these commands in it Text: PokeMacro - CTRL A =INITIATE("DASOMFINSEnet","TOPIC1")...