hardcoded

I have a spreadsheet that will auto send an email, attaching the current spreadsheet after the user is asked to save the document. The email works fine with everything hardcoded. I even included email addresses on another spreadsheet on a server that this WB points to so the To and CC are always...

My mind has been wandering this cold, winter evening and came upon this idea. Think in terms of a hardcoded password ... How would one go about placing all of the data for a database in the VBA macro code (hardcoded) instead of listing it on a sheet in columns and rows ? And ... how would you...

Hi all, Im not new to the forum but been a while since I posted. I have a sheet that is pre-populated with cell formulas. in a different cell i would like to evaluate whether BOTH cells do NOT have formulas. in trying to combine into an IF(AND(NOT(ISFORMULA() it returns an error. any ideas...

HI in the attached file NEW SITES & RENOVATIONS.xlsx - Google Drive I have to re arrange the data the target is to create sheet 2 based on the information in Sheet 1 column C ( take only data containing words "Renovation", "Disposal", "New sites" ) Sheet 2 row A is hardcoded so no code...

I am wondering if someone could provide some insight; I am having trouble getting over the concept of ranges - why I am having trouble with Range(Cells(4, 3), Cells(88, 12)).Copy and no trouble with Range ("C4:L88").Copy I thought I may have read somewhere where it has to do with...