suit

Hi all I am using the code below to replace the formula in a cell with a BeforeDoubleClick event but I am getting a syntax error. (Ex: If a cell is missing the formula, I just double click it to replace the formula) This is the formula that I am trying to paste...

Hi all I am using the code below with a BeforeDoubleClick event. I need help for the =CJ3 to be relative. If Not Intersect(Target, Range("c:c")) Is Nothing Then 'change this column to suit Target.Formula = "=CJ3" Target.Offset(1, 0).Select End If Thank you!

Hello, I have the following code with 2 macros and will like to run it all at once, how can I do this? Thanks Sub SaveSheetsAsFiles() Dim SheetsToSave SheetsToSave = Array("Rainbow", "RLN-Net Realization", "RLN-Red Rev", "RLN-COGS", "RLN-Logistics", "RLN-R&D", "RLN-Selling"...

Hello, I have the below code which attempts to select several sheets in a wordbook and save them on a separate file, but I'm getting the “Runtime-error '9'”: Subscript out of range, can someone assist to fix it? Thanks Sub SaveSheetsAsFiles() Dim SheetsToSave SheetsToSave = Array("Rainbow"...

I came across this code while searching the from the net . I need some explanation to what is happening so I can modify it to suit my needs. Why the number 809? Should that number be used for all other symbols ? Please help With Me.MBStake.Text = Application.Text(Range("MBStake").Value...

This gets me every time.. looking at the worksheet Cell I see 2:15 But reading Cells(row, Col) in VBA results in 0.09375. I think this is because the cell is formatted to suit a different data type. Is there a solid way to get "2:15" ? I tried CStr but no change.

Locate suit formations after typing the desired digits in a field Then in a huge left list with over 10,000 suits * Macro will filter according to selected or selected digits * De = 0 1 2 3 4 5 6 7 8 9 * Example selection = 0 1 2 3 4 5 6 7 8 9 ********************** Suit = 01 34 781,6,5,7,0,2 is...