see the basic function structure function test (first as range) whatever I do inside end function calling the function and first is the address of the first c
I can declare a static byte array in VBA like this, but it appears that the elements are not of type byte. Dim A As Variant A = Array(&H9F, &H2C, &H
I am not trained with coding in any way, but have in the past managed to use codes I found online as part of excel or access using macros or buttons and things.
I have a macro which theoretically works perfectly but I think it is creating unnecessary processing and calculation requirements which then crashes the file. I
I am a newbie to vba code but have had some marginal success with basic macros for changing the format of tables, text and photos within Word documents. I have
I built a VBA Sub that matches an input string with the equivalent string within a large array and returns a specific string which is bounded to the matched str
I am new to the forum and VBA codes. I have been searching for an answer to this question and am completely lost. I have a workbook that contains around 36 work
I have a VBA User defined function which takes multiple range references for using it in the code. My problem is when I try to use a particular range reference
so i'm trying to use a macro to look in sheets one code and paste the information of that code , I'm trying to use a simple macro with advanced filters to do th
I was using selenium with VBA and there is the current webpage. I was trying to get the bot to select the "exportbutton" ID, but I have already tried Findelemen
I'm a VBA NewBe (this is my first post asking a question on any VBA help site) working on a Property/Expense Management application in excel. the ComboBoxes in
'For the most part, I understand how arrays work but apparently not multidimensional ones in VBA. Below is a simple subroutine in which I want to debug.print/ac
I have downloaded some data from Sharepoint in *.iqy format (this is the only format in which the data can be downloaded). Post this, I perform the following st
My aim: I have a subform in a form and I want to pick up the value of one field in a user selected record in the subform and populate a field in my form using t
i want to make a connection with a DBF file through VBA, i have installed all the drivers but i get this error message every time i try to run it Object variab
I'm trying to mark messages, copied from within an Outlook subfolder to Inbox into a file system folder, as read. Sub demo1() Dim objNS As Outlook.NameSpace
I am a real novice at VBA, so any help would be welcome. I am trying to convert certain ranges across multiple sheets into only one file. I have written code fo
I am trying to generate some code that will open up an excel file on Sharepoint and copy data into another spreadsheet. I have been using the below code when th
I'm trying to make a button in Access, that will open Visio and launch a Data Wizard to create a diagram. I've tried various solutions, but all I get is opening
Im working on creating an macro that will pull data from a specific group of ranges across many files in one folder and feed that data into a master file in the