rangef2.select

  1. G

    Macros not running properly. Can anyone assist?

    Hi I have a workbook and run this macro first OK Sub Split_Extract() ActiveSheet.Name = "Extract" Range("A1").Select Cells.Find(What:="WFJ", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False...
    • ghrek
    • Thread
    • 2nd activesheet.paste macro rangef2.select run
    • Replies: 1
    • Forum: Excel Questions
  2. B

    Setting up a Macro to run on a highlighted area

    Hello, The computer system my company uses exports to excel in an ugly and unusable way. Normally i manually sort the data but I recently took an excel course and learned a bit about macro's. I have a macro set up to auto format the data but i was wondering if it can be set up to run on a...
    • bchemist
    • Thread
    • activecell.formular1c1 data rangef2.select selection.numberformat type=xlfilldefault
    • Replies: 6
    • Forum: Excel Questions
  3. U

    VBA array with variable rows

    I have an array with 5 columns and variable rows. I am using Vlookup, which works for the array I have, with 5 columns and 13 rows. The code is as follows: SUB macro1() Range("F2").select activecell.formulaR1C1="=IFERROR(Vlookup(RC[-1],R2C1:R13C5,4,FALSE),0)" Range("F2").select Selection...

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