underlined

  1. P

    Underline a specific part of a text string using VBA.

    Hey all, Currently I'm working on a question that i'd like to look like this: <tbody> What is the value of the underlined digit in 8512? </tbody> The digit i'd like to underline is in cell X6 and the text string is in cell C9 (the formula for which is ="What is the value of the underlined...
  2. J

    Need VBA to open and copy data from excel(.xls) file located in sharepoint/intranet with partial file name.

    The location in sharepoint is- <colgroup><col width="72" style="width: 54pt;"><tbody> http://workspaces.abc.net.au/healthcare/op/AutomatedReports/ </tbody> Name of the file is- <colgroup><col width="72" style="width: 54pt;"> <tbody> shrinkage ovc yesterday2018-08-08T08-01-06-146...
  3. E

    Cell Borders in VBA

    ActiveSheet.Range("A5:I50").Select With Selection.Borders(xlInsideHorizontal) .LineStyle = xlContinuous .Weight = xlThin End With My range of data changes as I add or remove information from my table. Is there a way to modify this or add a few lines so...
  4. R

    Linking to Another Sheet

    Hi all, Scenario: I have a multiple sheets in a doc. I would like to, in text, write something like: "As seen in Sheet 1" and be able to click on the underlined text and have it take me back to the sheet. Is that possible? Thanks
  5. F

    Identifying non numerical headers

    Hi there and happy newyears! What I have here is essentially a word document that we'v taken and copy-pasted all the information into excel. We currently use a macro that is identifying all the information and then seperating everything into each column. The one thing that the macro is not...
  6. I

    Help with generating a list/table/array with info entered

    all this info would be entered into a table/array <tbody> R x 201 x 202 x 203 x R 506 508 x 510 x </tbody> and then i want to activate a button and check if the x is in the box then generate a whole new list/table/array and the out come will look something like this <tbody> R...
    • Ivn68
    • Thread
    • bold entered info list/table/array underlined
    • Replies: 2
    • Forum: Excel Questions
  7. A

    VBA - Text centered, underlined and other font color

    Hi, I've got following VBA code in in addition I want the text to be centered, underlined and the font color RED. Could please omebody help me out. Many thanks in advance <tbody> Private Sub Worksheet_Change(ByVal Target As Range) If Not (Application.Intersect(Target, Range("A1:A10")) _...
    • akalien
    • Thread
    • application.enableevents end target underlined vba
    • Replies: 3
    • 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