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...

Some videos you may like

This Week's Hot Topics