lighting

Hi Excellers! Best wishes for 2019!! Is it possible to save Excel spreadsheets to local storage or to attached storage (lightning to usb adapter)? Any solution? It seems Excel for iOS forces one to a) login (to a MS account presumably...) b) store files to the MS cloud I've had numerous...

Hi, I think i have bite of more than I can chew.. looking for some help please? Ideally i was trying to write VBA to check sheet "CFRA" in column G for the word "lighting" IF true move entire row that contains lighting to "lights"sheet. With no luck I used a formula to deter if "lighting" is...

Hello, first time poster here So I've got a workbook that I use for creating checklists. I have a column that has the title "Staging / Lighting" which can move anywhere in the range H3:H200. So the way it works is on another sheet of the workbook, I go through and click on different things...

Greetings, I am using the following sub to save a single WS from a WB onto a network drive and it works flawlessly. Sub ExportElReport() Dim wb As Workbook Sheets("Emergency Lighting Inspection").Copy Set wb = ActiveWorkbook With wb application.DisplayAlerts = False .SaveAs...

Hello, I am getting an object variable or with block variable not set error when I add this line "Unload DataEntryElGr" to my code and I can't figure out why, the code runs perfect until I add it.... The sub is in the "DataEntryElGr" userform, The purpose of this string is simply to close the...