thought

Hi Excel defines ActiveSheet as following: (using object browser) property Activesheet as Object Read only Member of Excel Application My question, what does object means here? I thought the correct definition should be Activesheet as Worksheet Thank you very much.

I'm using the offset function and I am having trouble. I'm looking for a way to return the formula from a cell rather than the value. I will explain here below I have 3 cells a1, b1 and c6. a1 = apple, b1 = a1, c6 = offset(a1, 1, 1). This is where a1 is the reference cell. However I want to...

Hi That question is answered in the article below. The author is saying macro and vba are different. I am very confused now. I thought macros (recording macro) are vba sub routines, am I right? I thought these recorded macros will be saved as vba subs...

Hello! I am a brand new member, long time Excel user. Yesterday, thought I had lost it; Here; https://support.office.com/en-us/article/copy-visible-cells-only-6e3a1f01-2884-4332-b262-8b814412847e It says this; And that has always been true in my experience. I remember finding Alt+...

HI All Hoping you can help me sort this out. I thought I had it but not working how I want it. I have a formula that I am changing daily to include one extra cell in the formula. =((SUM(Daily!BL10:bt10)-SUM(Daily!BL4:bt4))/SUM(Daily!BL4:bt4)) The range is all the way up to CP4 or CP10...

What I want in the cell basically is that if B17-b16 is a minus figure, then use B12 + b13 I thought something along the lines of =IF((B17-B16),"<0","(b12+b13)") but I just get <0 as a response Any help please? Thanks Antony

Mornning How do I add to a total eg A1 =10 B1=10 , A1+B1= 20 - what want to do is add to the total - add another 10 then antother to get total of 40. Thought it woul be simple but it has me stumped

Trying to get 3 address fields to combine into one. I tried =b2&” “&c2&” “&d2&” “ exactly how I've read to do it but I keep getting a NAME? error. I thought this would be an easy one but I'm going wrong somewhere :banghead:

I just got sent a spreadsheet, obviously written by someone who doesn't actually use it, with countless vlookups against huge, whole column arrays! I've shortened all those ranges down and converted to index/match which has obviously helped massively. Im thinking to change to...

hello every one, I have a line of code that I'm working on, it auto sums the data from column "A" and puts the sum, one cell below the last, what I'm trying to do is have to sum appear in "W1" instead of the cell below the last, any thought? [CODEWith Sheets("DataDump8") Dim Lr As Long Lr =...

My plan (probably a poor one) is to create the North wind database from scratch. export the data from the tables into excel then build new tables in a blank access database and then import the data back into Access. then go about making the queries forms and reports. and i don't mean blindly...

People, Please lend a hand. I want B1 and then C1 to conditionally format with a green fill if they equal 90% or more of cell A1. Looking around I thought this formula I found would (for cell B1) do it =(B1/A1)>=0.9 But it didn't format. And I cant figure it. As ever, thanks <tbody> A...

Hi everyone, I'm looking to export my bank transaction statement into excel and want to create a list of snippets with categories so I can auto categorise some ofm y statements. I thought maybe a vlookup as an array, but this didn't work...

Hi Can I have 2 data validation rules applied on the same cell? For example I want user only enter text in cell A1 and the text should be at least 2 characters. So I thought I should go to Data Validation-->Custom--> Formula and use this formula =isText(A1) but how can I control the length...

Hi The result of above formula is 320? Why division has higher priority than multiplication? I thought the order of Operations is PEMDAS So M before D?

I thought it would be rude to just pop in with a question and no introduction... so I thought I'd come to the Lounge and say hi. HI! I'm from Texas and I am new to this whole Excel VBA thing with my current project. It's definitely interesting and I hope it leads to bigger and better ones...

I have a cell which has a formula result in it which at the moment is like this; That cell can have any one of a number of different values in different formats, but I'm trying to find a formula that can tell me if the cell value has a hyphen in it. I thought doing something like *-* would...

I was wondering which of these two indirect formulas (that preform the same calculation) would use less processing power and not slow Excel down as much? Looks can be deceiving so I thought I'd ask those who would know for sure. =INDIRECT($A$1&CELL("address",$b3))...

My Data: Row 1:2 are headers Columns are A:W Data starts in Column A:3, A:A is a unique number, never blanks or null A...B...C...D...etc...T...U...V...W 1...d...t...d...etc...20...30...40...50 2...b...c...d...etc...33...56...78...90 3...e...f...g...etc...21...8...16...55 ~200 rows What I...

I've got some code that I've been having a minor issue with, so I wrote a bit of error handling code to take care of it. With part of my handler code I wanted it to write the error number and description into a cell on a sheet so that I can track when the error occurs and what error. I've...