methods

Hi Lets say you have a big table and it has some cells which looks empty but has space as a character (user used spacebar to delete content). I know there are many way to spot these cells but I would like to learn different methods or how you would do it yourself. one option I can think of is to...

Hi I tried to google this but do not know the name of the list. When I type Workbooks(1) for example and then the dot, I will get a list of all methods etc. What this list called? How I can control it. I mean if it was not there, can I go to settings and enable it? Thank you very much.

Hi, I'm fairly new to Excel and trying to setup 2 Columns. Column A will have a regular text entry (name) and then I'd like column B to give a Date and Time stamp every time I enter a new text in each respective cell in the A column. I tried various methods I found online but nothing worked...

I have a large sheet that relies on a lot of live ranking. Is there a speed / efficiency difference between the two formulas below? (Obviously trivial for the tiny data set I used to create the image, but my sheet pulls in live stock data and is live-sorting 1,000+ cells that update nearly every...

Hello All! I have a macro that sorts a raw data set and adds a bunch of buttons. Those buttons call methods that search for a specific data set, sort data, or build graphs. It all works great when used on a single computer, but I'm having trouble if the document is emailed. If I run the macro...

Hi all! I have a database that has been split into multiple backends, and I am trying to troubleshoot and speed up a number of queries that are bogged down by joins to tables in each backend file. I have attempted to create a persistent connection using two methods: 1) I created small tables...

Hello all, First time Poster here, and novice in coding in general. My issue I am having is more a question of knowledge I feel. I am looking to scrap a java-script table on a secure site. So far I am able to log in but to get to the Data I want. There is a few buttons and links I must click...

I am trying to use the Find function to find the last location that a word is used in column A. Below is my current code. I have tried various other versions and methods, but cannot seem to figure this out. Sub Find() Range("a10000").End(xlUp).Select Range("a:a").Find("Count").Select End...

Frequently when I write code such as the following... Sheets("Sheet2").Range("A2").Paste I get runtime error 438 "object doesn't support this property or method" I usually just change it to .PasteSpecial or try another way of pasting and work it out. However, I have never understood why...

I am currently tying to change filter values and process my brio query through Excel VBA. I have created a BrioQuery.Application object but I do not know the properties and methods of this object. Could someone direct me to it. I have looked in BrioQry.tll object browser and it doesn't...

Hello, I need to make a graph for a set of data shown below <tbody> 20 degrees Liquid 40 semi liquid 60 semi solid 80 solid 100 solid </tbody> I have tried countless different methods and cant find a way. The right hand column needs to be on the y-axis. Cheers for any help OldBirch

Hi All I'm after a bit of advice please. I expect someone has done this before. I have a list of 1000's of unique numbers between 1 and 6 digits that I want to increase all of to 8 digits. The problem is that I cant keep the existing numbers in the same order as they would be easy to guess...

Can anyone suggest a way I can do this? I get up to about 120 criteria before excel tells me that the formula is too big. Any suggestions of methods I could use to expand it to 900 (I know this sounds excessive)? Kind Regards.

so i'm reading this link https://msdn.microsoft.com/en-us/library/office/bb687915.aspx#sectionSection2 i've created a spreadsheet i'm able to do a Public declare of my DLL function called "myfunc" and write a VBA macro calling that DLL function called "mymacro" then i enter that macro name...

Hello, very new to Power Query, I am using excel 2016 Here is what I have. The actual column names is: HSD Models and Methods you would love to practice more with the support of a "method mentor" from the network Only part of the Column name is showing in the table HSD Models and...

Hello all Is there a difference or efficient way to find the last data in a column of the two. In the Forum I see both methods used. Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row Sheets("Sheet1").cells(Rows.Count, 1).End(xlUp).row

Hi I have imported a reference library to play with in VBA. Library is called IMAPI and its used for burning CDs, DVDs etc.... It contain two references IMAPI and IMAPI2FS the IMAPI2FS is a filesystem reference. where you can manipulate with filesystem choosing which files to burn. Methods...

Hello! I am new to the forum and to excel. We have a huge excel database that we would like to transfer to an SQL Server. The database consists of PowerPivot tables and some regular ones that apparently come from tab delimited text files. The problem is that to mimic the PowerPivot...

Dear Experts, I learned how the Intersect and Union Method works in VBA. however i have never came across any project to use this referred method. i would appreciate if someone could depict the Intersect and Union method and for what they are used for and how useful it is. best regards,