set range

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

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

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

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

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