excel macro coding

  1. J

    Create individual Text file from each Excel 2003 row using Macro

    Hello !! I am completely new to VBA. Can someone from community help me achieve following. I have an excel 2003 worksheet with three columns data as follows: <tbody> SYMBOL LISTING_DATE FV 20MICRONS 06-Oct-08 5 3IINFOTECH 22-Apr-05 10 3MINDIA 13-Aug-04 1 8KMILES 29-Jan-14 10...
  2. S

    removing duplicate rows in excel using vba based on constraints

    Hi I have a requirement where the duplicate rows has to be removed from a range of columns. Example input: RowNo emplid firstname phonetype phonenum rownumber deptid deptname joindate rownumber 1 1001 abc home 88888 1...
  3. S

    How to compare two coloumns and restrict it values to be entered

    Dear experts please help I have two column submit date and recived date in excel 2010, I want to put restriction on recivd date coloum. <tbody> submit date recived date <tbody> 16-Feb-13 </tbody> <tbody> 8-May-13 </tbody> <tbody> 6-Nov-13 </tbody> <tbody> 20-Jun-13...
  4. A

    VBA Hide Text

    =
  5. D

    excel to txt

    Hi all, I'm trying to export from excel to .txt. I have a row of column headers in excel but they're not exporting to the .txt option. (which was the original plan, but now needs to be reversed!) Here is my code so far. It does everything I need but include the row of column headers, such as...
  6. B

    Copy 7 columns on 1 row and Paste transpose

    Hi, I am looking to be able to do the following. 1) Go to cell, copy 8 cells to the right. 2) Paste special transpose 3) Got down 10 rows from top of transpose result and repeat action, until no more data. Hope someone can help. Kind Regards, Heath
  7. A

    Excel VBA Macro to make highlighted cells be the same as the next non-highlighted cell above it

    This sounds complicated, but this is what I have to make a macro of for work. Listed below is a sample of the list of item codes that I have: ('h' stands for highlighted cell) M101 S644 (h) S753 (h) M102 S531 (h) etc.... I want to make the macro to give this end result using...
  8. J

    HELP NEEDED: Open an existing internet explorer window using vba macro

    Hi Everyone, I've been using excel for quite sometime now but it's my first time to do macro scripting. I need help to have a code that allows an excel button to open an existing internet explorer. I found several codes but what it does is open a new window and it takes few minutes to load the...
  9. E

    How to add CC in VB codes while Creating Excel macros to be sent via outlook application?

    Hi Friends, Please can anyone help me out in this below task. I am creating a macro file on which the excel file contents needs to be sent through outlook application, I have codings to add 'To' field, can anyone help me out to add 'CC' & 'From' fields. Private Sub CommandButton1_Click() Dim...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top