macro add value

Hello Anybody willing to lend a hand? I have a button that uses the following macro: 'Ensure weights sum to 100% and are placed correctly msg = "" toolsCt = WorksheetFunction.CountA(toolsRng) weightsCt = WorksheetFunction.Count(weightsRng) Select Case toolsCt - weightsCt Case 0 If...

I need to pass the value of a variable from one procedure to another without running the entire called procedure Private Sub openReport(ByVal strProductFile as string) MsgBox "Open previous week's report.", vbOKOnly + vbExclamation, "Open" Application.Dialogs(xlDialogOpen).Show...

Hi, I would like to add a value of 7.5 every 15 days to a column with 30 rows. Please let me know if it is possible. Regards, Siddharth

Any help on this is much appreciated!!!! I'll do my best to explain what I am looking for,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have an excel book we use to run a quarterly report which has one worksheet for each of the company's...

People I have a macro with several Userforms. And, from one of them, I calculated some values and save the result into the variable "Z", as described below: Z = Z + (Cells(Rw, colPQuantity) * Cells(Rw, colRUnitPrice)) Now, I need to capture that "Z" value using another Userform and...

Hey fellows, I have the code described that basically capture a sheet from another workbook and paste in the active workbook. However, the problem I'm facing is, for each column the code only import the majority data (between TEXT or NUMBER) for each column. For example, if in the column "C"...

I would like to have a macro that simply adds a 1 to the value of the cell selected. Not sure how to proceed. Thanks for any help & yes I did try to find using search but must not be wording search correctly.:nya: