set range

  1. D

    Change range of values in one command button click macro

    Please be nice to me, I'm trying to learn VBA/macros by my own again after 15 years of not doing it :( I know this is basic but huhuhu anyway.. I know how to change a value of a cell by a command button, but how do I change all of those values in one click of the command button. See my attached...
  2. S

    How to use a user-selectable range from an InputBox

    Hi, I'd appreciate some help with the following: I have Sheet1 and Sheet2 of same Workbook. In Sheet1 I have a base list of part numbers. On Sheet2 I have a list of part numbers that vary; more part numbers are added to this list daily. The objective is to identify which new part numbers (out of...
  3. F

    Defining Range with SET keyword

    Hello, I'm trying to define two ranges using the "SET" keyword function in VBA, but my code does not seem to be working. What I want to do is to be able to activate the macro from any worksheet or cell in the workbook and the macro should take me to the defined range. However everytime I run...
  4. C

    Setting Variable Range for use in filter

    Hi All, I'm very new to VBA and I'm trying to teach myself, but I've hit a wall. Here's what I'm trying to do: 1. I'm trying to Copy a set of data from one workbook (working ok) 2. Paste that data to a different worksheet that already has other data starting with the first blank row (also...
  5. G

    Selection Range

    Hi All. i need to check values in the selection and perform some calculation accoringly Selection can be vertical as - A1 P A2 P A3 P A4 P A5 P A6 P A7 P A8 P A9 P A10 P or Horiz. as - A1 A2 A3 A4 A5 A6 A7 CL CL CL CL CL CL CL i want to set range accordingly and do the calculation using...

This Week's Hot Topics

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
Top