selection.value

Hi Folks, I have been asked to generate an online excel spreadsheet and automate some functions that I would normally use VBA for. I've read a bit of intro material, but Office Script seems alien to my brain right now. How would one replicate the following VBA code? Sub setvalue() Dim ws...

Is there a simpler way or loop to run through this code so I don't have to write this out so many times? Any help would be much appreciated..... Johnzea Range("E59").Select Selection.Value = Selection.Value Range("E60").Select Selection.Value = Selection.Value Range("E61").Select...

Hello, The code below gives Type Mismatch 13 error: Range("F1").Select Do Until Selection.Value = Sheets("Cortes Proporcionais").Range("L4").Value Selection.End(xlToRight).Select Basically I want the code to press right until it hits the cell equal to Sheets("Cortes...

Hi All, I have a macro that inputs a formula in 5 rows in named range in Sheet1. The formula references "static" cell ranges in Sheet2 that are inside of a table. This all works fine, except now I want to filter my table in Sheet2 and have the formula reference the visible row instead of the...

Hello! I am trying to make a sheet that is as easy-to-use as possible for the end user. I've made buttons which I would like to use to add extra information into the selected cells, without deleting any pre-existing information. All info will be text strings. The selection the user is making...

Hello, it will be a stupid question most probably... Why in VBA we are using the following: "If Not Selection.Value > "" If I'm correct that this basically means "if selection value is not bigger than nothing", which mean if value is 0.. There is no "If Selection.Value = "" for this or why...