compile

Hi one and all, I am trying to use VBA to put a very long formula into a cell, why such a long formula? Don't ask! When the code is entered into the cell as a formula, manually, it worked fine. But after coding the formula into VBA using multiple next line continuations " _" (because it is such...

I'm trying to get some tables from the web to put in excel and in my VBA code I'm receiving an error on VBA below I will post my code and if someone can check where is the error, and what I need to do to fix it the problem that I'm having. Thank you. Problem pic Sub GoToSpace() Dim BaseURL As...

Hello - I have the following macro and it is hanging up with a "next without for" compile error. I don't see what is wrong with it? Could someone please help me? It is hanging up on the line 'Next mycell". Public Sub ProjNumbrReq() 'Call ProjNumbrReq Dim myCell As Range With...

I am getting a compile error: Syntax error on this line, but can't figure out what the problem is. I am obviously new to this. Mess = Replace(Replace(Mess, "#FirstName#", FirstName), "#team#", Team), "#gamedate#", gameDate), "#location#",Location), "#gametime#",Time"), "#field#",Field))...

Hi everyone, I hope this is only a setup condition that someone identifies, but the transition from Windows 7 and Excel 2010 to Windows 10 and Excel 2016 has caused a lot of agita. For starters, environ("username") was not recognized (compile error Can't find project or library). Found out...

I have multiple worksheets with item names in column A and their corresponding colours in column B, of each worksheet. Each sheet may often have different item names in column A, same names but different colours and their positions may change based on their ranking. I want to compile a list of...

Can anyone tell what the prob might be. Getting compile error on start up. Used to work fine. Then they upgraded to Windows 10. I suspect a 32/64 bit confliction. Any suggestions? Thanks Option ExplicitPrivate Declare Function ShowWindow _ Lib "user32" _ (ByVal hwnd As Long, _ ByVal nCmdShow...

I'm an trying to get concatenate string of text that will be a large formula into I2, but I receive a Compile Error: Argument not Optional. Here is my most recent code. Dim Form, a, b, c, d, e, f, g, h, i, j, k As String Dim TxtRng As Range Dim wb As Workbook Dim ws As Worksheet a =...

Per the below macro, i am getting a compile error for the line in red. In short i want to see if any row in column D if there is a Number 5080 than print the word NOTHING otherwise the word NONEED, than goto the next row. can someone let me know where the error maybe? thanks Sub Nyexcel3()...

I have a need to turn off ThisWorkbook.AutoSaveOn if it is on. Easily done, however if the user opens the workbook using 2013 or earlier, the VBAProject fails to compile. Perfectly understandable. My question is ... is there a way to code the test in the VBA but "ignored" if not valid? For...

Hi Everyone, I'm trying to compile 6 worksheets from the same workbook, into 2 separate worksheets. In this instance I am trying to copy data from the 3 publisher content tabs into a master sheet, but I am getting an error with this line of code For Each ws In...

Question for you. Sheet 1&2 name titles need to be changed with the following titles: Sheet1= PrePaidReport, Sheet2 = NewFormat, after I made the changes inthe VBA Script, Sheet titles change to capital letters, then I get, "Compile error" displays, "Variable not defined".

I'm really new to VBA coding and would highly appreciate if you can help me with the error as per the screenshot <a href="https://ibb.co/hmRVfHr"><img src="https://i.ibb.co/ZM6xmKv/Compile-error.png" alt="Compile-error" border="0"></a> https://ibb.co/hmRVfHr

In the below lines the first 6 and the 11th work, but lines 7, 8, 9 and 10 don't work Do you have to use Sheets when using ThisWorkbook [myrange] = "Yes" [myrange].Offset(0, 1) = "Yes" Sheets("Sheet1").[myrange].Offset(0, 2) = "Yes" Range("myrange").Offset(1, 1) = "Yes"...

Hi all. I recently made an excel VBA project which then turned out to be a huge application. This application is being saved in a network shared folder where multiple users are able to access the file (only one at a time though). So, this application runs smoothly thus far on multiple machine...

This code is periodically crashing excel when a user doesn't save a workbook. Sub FillLog(uName) Option Explicit uName = Environ("UserName") Sheets("Values").Cells(10, 43) = uName End Sub I ran the "Compile VBA Project" from the debug menu and it gave me an error or "invalid inside...

In general, is/are there condition(s) in which Excel VBA will not recognize a "Select Case" statement? My current project is failing to compile (Error: Case without Select Case)) even though "Select Case" is obviously in the code just above the first case. (It is not within another Select Case...

Aloha - I am trying to compile a list from a column and count the number of times the variable appears. In Column D I would like Excel to look for a specialty when it comes across a new name put in under the specialty box, column F. Then I would like to display the number of times the variable...

This is the error message: "Compile error in hidden module: mMenuAdd"

Hey everybody. I've tried to make some simple calculations, but you see what happened. What is the reason of the compile error?