native

  1. L

    is this left() VBA or Worksheet function

    Hi I am reading about dealing with text in VBA (the link below) and I see code similar to the one below. My question, this left() function is VBA native or Worksheet function. My guess is VBA native. Thanks a lot. Sub myleft() Dim x As String Dim y As String x = InputBox("enter...
  2. M

    Transposing n rows into columns

    Hi everyone. I am trying to make a chart with demographic data, and I need to rearrange the data. I've been searching for a thread about this query, but all I found refer to Multiple Rows to Single Columns, and resulting columns on top of each other. My dataset is a table of 103x496 and I cannot...
  3. M

    Native DB Query Prompt - when sharing workbook

    Hi There I have a workbook which uses Power Query. I have tried the various suggestions I have found online for disabling the Native DB Query security prompts which seem to work when I refresh the workbook on my machine. However when the workbook is shared with other users it seems to ignore...

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