SQL 'CREATE TABLE' Syntax issue

how to get address cell

How to skip blank columns in copy paste function?

How to scan the complete file and display a popup if some of the keywords exists

Antecedent ActiveCell.Address

Search name from workbook field (person's last name) and see if it is in a 2nd workbook. If not, create list

Frequently called subroutines/functions: copy to each module and declare Private or keep in one module and declare Public? Performance?

Formula to repeat a previous row multiple times based on a number in a cell

Select long text from SQL using Excel VBA ADO returns garbage characters

Why are FullSeriesCollection format changes affect two data series at the same time?

User will enter range of columns and each column will be saved in a new workbook

Change Worksheet CodeName in protected VBProject

If-ElseIf-Else Code is skipping Else block

Excel - Multiple Complex IF conditions using 3 Tables

VBA Excel Code differentiation based on cell value

How to filter based on clipboard?

How to use the Average function in different cells?

Vba Concatenate multiple columns until blank

How can i export from excel file to a csv file the fiel with left zeros on the references, in text formate?

Cut and Paste Blocks of Data underneath first block using VBA

Clear Contents of Visible Cells in Filtered Column

VBA pareto chart for a qualtity defects excel table

Tables. Update cell if another cell changes

How do I fetch all of the info of the elements I specify?

Loops in VBA: what is better? Loops which end on their own vs using ExitLoop. Performance, good practice, bugs?

How do I use Microsoft Packaging API with VBA to manage OpenXML files..?

How to make a VBA Function that will apply "IF" Formula's to a set of values that contain special characters for conditions

VBA - Change Power Query Date Source

Quotation marks in a complex formula including a variable

How to translate Excel Coupon Days Function in SQL Server?

I need help to process some data in excel vba

VBA loop to generate graphs with changing data set amount

How do I make the Form disappear when a button is clicked?

Excel VBA / Split String Into Columns based on Character Count

FormulaR1C1 in For Each and If function

Getting data from closed workbook and assigning to a variable

2 Condtions Do While - Excel Macro

Fixing Excel Pivot Drillthrough with VBA for sum of 1/0s across multiple fields

Attaching bespoke files to bespoke emails from a list in a spreadsheet

How to calculate producers time to profitablility ($20k/month) company wide with different start dates

Web Scrapping details from name hyperlink present in table of web

How to add value to a set in vba

"Object required error" on string contains check in excel- vba

How to fix the format and change file from xlsm to xlsx

Excel ODBC link to SQL Query for results between to dates

Using cell address of a private sub inside a UserForm

How to make Excel VBA Export as PDF on MAC computer

Day and Month swap when used in other machines. How to fix it?

Use only one worksheet or multiple worksheets in Excel? Better performance?

I am having trouble understanding certain parts of this code. What is break_space_position and what are the bounds of this For Next loop?

SQL JOIN Query run based on dates entered in Excel

Is there a way to track modifications made by a specific user in the past week, and then sum up those changes on a separate tab?

How to set a formula from VBA to assign cell value?

How to interact with autoExtender in html with VBA

Run-time error '1004' The file could not be accessed. Try one of the following:

running balance and runnig total with SQL

Combobox which returns all numbers of an ID

How do I enable the right-click macro for tables?

How to get userform lable to vlookup from textbox1 in userform to another sheet?

I am getting different result with my excel Copy then Paste code

How to get the innertext inside a tag?

Clicking ID in Internet Explorer VBA does not register anything?

Create Shortcut via VBA

Error 440 After I add application.displayalerts = false

Excel images to appear based on cell value

Trouble adding an object to a collection in excel VBA

How can select a VBProject from vba?

vba from 2 different worksheets

Create a named range based on a value in another column not included in range

How to group Column Data with like Name to find Sum, min, and max?

Selenium on excel vba xpath unable find. no such element error

Delete part of a string from one set of characters to another character

One MsgBox To show all passes and fails

Select from a table without column name

Code that force You to type specified text in a cell

How can get Items in HTML code with VBA for automation

I need to extract data from multiple columns in a worksheet and paste the columns in multiple worksheets in another workbook?

Save some hidden Excel sheets in a file generated with vba

Copying data against a key column from other worksheet. (Trying to do as vlookup is not working in VBA)

Inserting a hyperlink to 2 different cells using the same criteria

Difficulty getting a copy paste formula to work and compress the paste area

I need to fill cells in column D with the contents of column A, if and only if column C says “Yes”

Need additional VBA code for PDF export from excel

Converting Excel to Json - how to structure Excel

Out of Memory Run Time Error 7 when i create New Pivot Table in Excel

Excel VBA : Hyperlink that fills target cell's contents with hyperlinked text

i need to split some data by specific conditions?

Copying the cells

How to test if a used range is null (doesn't exist anymore, as apposed to empty cells)

CMD command execution in the background From Excel Macro

Load picture script in VBA macro

Excel Vba Save file in pre-defined path based on static variable

Inserting Multiple Double Quotes In A Cell Using VBA

How can I transpose my timeseries data with a formula and copy the same cell value?

Excel VBA code broken after upgrade to Excel 2013

Data Scraping by Tag and Class

Run time error -214767259 (80004005) Automation error Unspecified error - Excel VBA - UIAutomation

How to optimize the performance of data pulling from a very large text file in excel via VBA

VBA xmlhttprequest loop without closing connection

Trying to find duplicates in a non contiguous range using Countifs