variable cell in vba loop

  1. S

    VBA to insert a formula that uses A1 style fixed column variable row

    Hello, I need some help. I am looking to have a macro write a formula into a cell using the A1 style. I need to be able write it as $D + Y, where Y is a variable number I have. I can't get the syntax correct. Please see below... This one works perfectly... copyWs.Range("B" & Y).Formula =...
  2. G

    Macro to copy column based on header list selection from Worksheet1 into relevant column of Worksheet2

    Hello, I need help using a macro button to copy column data based on a dropdown list selection from worksheet1 into worksheet2 where the column in worksheet 2 equals the dropdown list selection. The use is where I have multiple sales people using a shared workbook to enter orders on worksheet1...
    • GrantG3SA
    • Thread
    • columns based on selection copy button macro - copy variable cell in vba loop
    • Replies: 3
    • Forum: Excel Questions
  3. J

    Multiple Variable For Loop

    Hello, I've written thefollowing code to look at each cell in column C of Sheet2 that equals each cellin column C of Sheet1. Sheet1 values will show up multiple times in Sheet2, soI want it to loop until either there aren't any instances of the values matchingand column G being blank, or it...
    • JessP
    • Thread
    • dim loop variable cell in vba loop vba vba loop
    • Replies: 9
    • Forum: Excel Questions
  4. A

    define variable range in a loop

    Dear friends, I wish to perform statistical calculations in very huge pool of climate data. what I need is to define a variable cell addresses and pass them to the formula to compute the output. for example I have the following as Temperature or pressure in different columns for different days...

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