macro problem

  1. S

    Need help adjusting VBA to change date formats in text.

    I am currently using the macro illustrated below, which has been working perfectly fine for a long time. The only problem I'm currently encountering is whenever it is processing data that contains text within sentences and paragraphs, it always changes whatever the current dating format is to...
  2. S

    Cap everyword in each cell of a column - macro issue

    Need help with this: I want to cap the first letter of every word within a cell, NOT just the first word. =proper(A) doesn't work for me because if a word has an 's at the end such as Physician's, it will also cap that s so it ends up as Physician'S. The following program works great...
    • skyport
    • Thread
    • cap first words in cell macro problem need help
    • Replies: 23
    • Forum: Excel Questions
  3. M

    Macro stops at each line of code

    I'm using two computers (both Windows 7 / Office 2010) at the office. The only difference is the older one is about a year older than the new one (and is a bit slower as well I guess). I've written a macro that turns different kinds of price lists into a data table. I've written it using my...
  4. E

    Macro & related sheet names problem

    <TABLE style="WIDTH: 317pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=423><COLGROUP><COL style="WIDTH: 317pt; mso-width-source: userset; mso-width-alt: 15469" width=423><TBODY><TR style="HEIGHT: 217.5pt" height=290><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT...
    • engbhs
    • Thread
    • active sheet problem excel macro macro help macro problem sheet name in macro
    • Replies: 0
    • Forum: Excel Questions

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