writes

I have a macro that runs with every entry in a worksheet named "A". When I write macros that reads and writes data to and from worksheets, I typically create a dummy worksheet where the data is stored simply to avoid formatting changes in the main worksheet from affecting the macro. Therefore...

Hi, I want an Excel page that when I write 1.01 in a cell it writes 99.01% in other cell, when I write 1.02 it writes 98.04% in other cell and so on... Here is the full table that I need: 1.01..........99.01% 1.02..........98.04% 1.03..........97.09% 1.04..........96.15%...

Hello, How do I write code to move on to another question if the information doesn't exist on my spreadsheet? My code is: 'Select Start of range Range("B1").Select While ActiveCell.Value <> "" 'This writes 'Cash' in column A against cash transactions. If ActiveCell.Value <> "" Then...

I asked this on another forum but the answer was confusing and they seem to frown on explaining why :( Supposing I want to simply write the first 3 cells of the first row, I might do this: <code><code>'writes to first row Set Rng = Range("A1:C1") Rng(1) = "blah" Rng(2) = "blah2" Rng(3) =...

Hello, I have a simple file where i put my times for work and the overtime. It looks like this: 2017-10-26 14:00-23:00 (30) (30) is the overtime. I want a code that writes this for me. So the standard-time is 14:00-22:30 and any deviations from this will show in another column. Thanks!