pointers

  1. V

    Copying formula to the next sheet and extend loop

    I have a list of 150 formulas in Column B I want to put the formula in B1 on the second sheet and extend it from A1:H200 Then I should grab the next formula in B2 and put in on the third sheet And so on Any pointers? Thanks for your suggestions, will help me out a lot
  2. mole999

    VBA Non Breaking Space Alt0160

    I have a large set of names, and I need to Transpose those into Last Name, First Name. 800 of which have either two first or split last names. I'm currently going through and adding an underscore _ but really want to convert the underscore to the non-breaking space. Everything I have tried so...
  3. L

    Increment values only when there is a zero in a cell

    Hello Forum, Hopefully someone has some pointers on this. Normally I can figure out little problems like this but this one has got me stumped. Obviously my Excel skill are not as good as I thought they were !! Here is my challenge... I have a set of numbers which are grouped, sometimes...
  4. T

    COnvert 32 bit API to 64 bit - Pointers and Handles

    I am trying to convert my 32 bit APIs to 64 bit. https://www.mrexcel.com/forum/excel-questions/1014816-convert-32-bit-api-64-bit.html Can someone please explain what is meant by: "But bear in mind that any variables in your code that hold Pointers or Handles will also have to change...
  5. W

    compiler objects to encapsulation of one line of code

    If I attempt to encapsulate one line, the compiler rejects the encapsulation The critical code is the following: Dim WrkBkPtr as object Dim WrkShtPtr as object Set wrkBkPtr = ThisWorkbook Set WrkShtPtr = WrkBkPtr.Worksheets(1) Const R as long = 2 Dim C() as long...

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