Search results

In the attached sheet you will find how I am getting the time it takes a room temperature to go from H to L when the Air conditional goes ON then it shows how long it takes room temperatures go from L to H. The test data shows fake data to simplify testing. I need to create a macro to do the...

I have a table of two columns one is time stamp and the other is energy reading in kw. The time span of the readings is one year. I need to create a chart with TWO sliding indicators. By manually moving the TWO indicators I can define a period in time and the chart will display energy consumed...

Public Sub List_Object0() Dim lo As ListObject Set lo = Sheet2.ListObjects("EmpTable") End Sub second line !!!!! Any Clue .... Office 16

Background: I have several financial forms in Arabic and I need to translate the Financial labels to English. Google Translate was not specific enough; so I decided to use my own dictionary. VBA has this powerful Dictionary Object. The problem(s): 1. VBA Editor does not like Arabic characters...

I need some general help in approaching this problem. Let say the bank gives you 11.25 % on your saving account. The problem is your saving account balance VARIES during the physical month, so the rule is the bank apply the interest on the MINIMUM balance during the month. For example ( taken...

I have a basic personal cash flow workbook. Sheet 1 has the bank balance AND the amount I owe to my 2 credit cards. I pay my CC's in FULL at a fixed monthly due date The second sheet contains the cash flow for say 3 month ahead. Any Income I get I record, as well any expense. Here is the...

Sub GetClipBoardText() Dim DataObj As MSForms.DataObject 'Dim r As Range 'this is just a trial, it did not work 'Set r = Range("b1:b???") ' unkown number of elements Set DataObj = New MSForms.DataObject On Error GoTo InvalidData '~~> Get data from the clipboard...

In the attached WB; the ONLY variable that I can play with is the commission. I put some kind of formula and please ignore it. The objective is to calculate the commission NEEDED to achieve the target(E23).

I have csv file of n lines formatted as follows: 40600 usec, 3560 usec 1560 usec, 580 usec 260 usec, 580 usec ....etc For EACH line I need to create TWO lines as follows: delayMicroseconds(40600); pulseIR(3560); ...etc I tried to record a macro to start me off , but I failed to...

Please refere to this http://www.nytimes.com/2014/04/29/science/to-divide-the-rent-start-with-a-triangle.html?utm_source=digg&utm_medium=email&_r=0 The calculator used by the site is a bit vague, so my and hopefully your challenge to make an excel model of it. Let the fun starts... P.S. I...

From what I read so far, I need to install mysql into my windows system !! Then establish a connection..!!! All what I need is to import the file. There must be an easy way to do that without the hassle of "learning" mysql !!! Your help will be greatly appreciated..

Here is my problem: Calculate electricity bill The progressive table 0001-0050 costs 0.05 0051-0200 costs 0.10 0201-0350 costs 0.15 0351-0650 costs 0.25 0651-1000 costs 0.40 1001 plus costs 0.50 I need to add accumulative costs to reach the final cost, in this table 1500 KWH cost 505.00...

The string text is Huge (HTML web page). The string starts with unique ID and end with </span) Here is an example <div id=currency_converter_result>1000 USD = <span class=bld>62785 INR</span> I need to build a function with 3 parameters ( str , start, end) start="...

Rows("19:23").Select Selection.Delete Shift:=xlUp Selection.Clear By not working I mean the rows 19-23 are Still selected !!! If I add Range("A1").select The selection goes away. i.e. cleared

Given Reference Date rDate Given Now Date nDate TODAY() Given Number of days nDays IF(AND(rDate>=nDate , rDate<=nDate + nDays , rDate<>"")),"GREEN","RED") I get GREEN Only when rDate is between Now and (Now + nDays) IF rDate is Blank I get RED. Can I eat the soup ????? :oops:

I need to BG a cell based on it's value IF A,B or C it is green IF D,E,F it is Blue etc So, once I past a value in a cell I need to call a function to evaluate it then give it the proper BG color.

Selection.value = "=TODAY()" Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues There must be a better way to "freeze" TODAY().......

I have x number of worksheets, representing x number of projects. each project has a number of tasks ( same tasks for all projects). For each project each task has a planned number of days per task. The "Planned dates" can be easily calculated for each project. A project starts when User Input...

The table consists of Date/amount/type I have a hidden column in the table that does calculated field ( I do not want the user to see it). Now I want create a pivot table Row Date Columns Type. Good so far. I need to filter based on the hidden column !!!!! This is my first question. Can I...

I have 4 one column tables TableA from 1 to 20 TableB from 1 to 5 TableC from 1 to 7 TableD from 1 to 3 All these tables can EXPAND. I need to create TableAB with all possible COMBINATIONA but no duplicates Same for TableBC, TableCD. In case you wonder I am trying to create test data to...

Let us say Sheet1 has 3 column with headers AAA/BBB/CCC Each column has data to be used as an aid for data entry in other tables (sheets 2,3,4) Now Each table in these sheets has various columns AND one of these fields is in sheet1 say HD1/HD2/AAA/HD3 etc The goal is when reaching AAA...

In my case an VBA Auto generated array resulted in whole outer column(s) of zeros and "outer" row(s) of zeros as well. All what I need is a resized array trimming all the OUTER zeros including zero valued columns. So, if original array 3@5 I could end up with a multidimensional array of 2@3. All...

Rather than describe the worksheet I am referring to it in my DropBox. https://www.dropbox.com/sh/5oc913rc25r4yql/YCHilxK3oF The core procedure is storing specific repeated range ( the yellow part) into an array where I do some complicated calculations. This one I need no help with. What I...

There must be a way to fill an array as easy as copy a range to another (copy and paste). Let us say I have a named range A1:D5. And I have an array dimentioned with the same size Array(4,3). What I want to do copy the range to the array, without having to double loop...etc Is that doable ??

Is it possible to avoid key pressing F8 while stepping into a vba procedure?. If I can customize the ribbon to click on an icon that will trigger F8, so I move one step at a time while debugging; thus avoiding the keyboard.!!!