hardcode

Hi! I have a big workbook that evolves around a cell (O3) In this case O3=11, but this number/cell changes several times during a working day. When running the macro, I need the vba to hardcode a formula to A2 with a number from cell O3 The working formula is: =IF(sheet1!B11=0,0,sheet1!B11)...

Is it possible to hardcode a date using a formula based on another cell criteria? Like if A1 does not equal blank B2 equals today’s date mm/dd/yyyy or can this only be achieved through VBA?

I am looking for code that will generate index numbers for ALL CommanBars I have been searching all over the place and can't seem to find it. Reason being is I'd like to use a number rather than hardcode >> "Cell" or "List Range Popup" for an example Dim Bar as CommandBar Set Bar =...

Hello Excel Community, I am trying to hardcode each worksheet in a workbook. I have the following code that gives an "Overflow" error when I run it on .Value = .Value Any help with the code please: Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets...

there seem to be lots of codes for this out there and I'm really close to getting it figured out.. I have a workbook that has 26 sheets, I want to create a macro that saves all sheets as hardcodes (completed) and creates a draft email in outlook with each sheet as an attachment. Created a...

Hey, I've been coming to this forum for help, so I finally made an account to ask some questions. I'm writing a vba that will change a column in a set of tables to the values based on the last row of data for each table. The number of tables isn't constant and is generated by different...

Hello, I have exhausted myself trying to modify this code to run ONLY in the range the user selects. I have also tried to add an error handling section with a message box in case the user selects a range that does not contain any hard-coded cells. 1) Excel 2010 / PC Windows Premium 7 2) Code...

Hello, I use a code to hard code vlookup - but is it possible to hard code cells with SUMIF formula's only? 1) I want to hard code any variety of SUMIF or IF formula on the active worksheet. 2) I want the code to only work on the sheet that is activated. 3) There are other basic formulas...

I am really new to Macros. I have devised a workbook which I would ideally like to archive a hardcoded version of at a particular time every Monday and to a particular network path. Is this possible to do? I am not sure how to write macro codes and seem to be struggling with finding the...