code clarifition

  1. C

    If cell contains text, then insert formula above VBA

    Hello all, I think this is my second time posting...maybe first! I have a spreadsheet that has information in it that will change, the columns will get greater and fewer in number as it comes from an Access Database. The number of rows will remain, always ending at 1202. Anyway, what I'm...
  2. A

    Pivot Table Macro only works for one workbook! How to make it applicable to all? Code posted

    Sub Macro1() ' ' Macro1 Macro ' DataSheet ' Creat Standing Data Pivot ' ' Keyboard Shortcut: Ctrl+Shift+Q ' DataSheet ActiveSheet.Name Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Sheets.Add NewSheet ActiveSheet.Name...
  3. E

    sub will not run

    Object to place hypens between inistials of name Only not just replace white spaces<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Example G K Aalborg would become G-K Aalborg <o:p></o:p> <o:p></o:p> <o:p></o:p> For some reason it fails and...
  4. pedie

    Need clarification on Code "Private Sub Worksheet_Change(ByVal Target As Range)".

    how many Private Sub Worksheet_Change(ByVal Target As Range) code can we have in a sheet? Can i have 2? Is that possible? Suppose I want the target to be B1 and then other range is D2:D7... D2:D7...has diffferent code and B1 has different code again so confused..:confused: Thanks for helping!

Watch MrExcel Video

This Week's Hot Topics

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
Top