insert

Hi all, I'm in a search of a VBA guru. I'd like to turn the following formula into a VBA Conditional Format code: =IF((SUMPRODUCT(COUNTIFS(INDIRECT("'"&Table1[SheetNames]&"'!$D:$D"),$D16,INDIRECT("'"&Table1[SheetNames]&"'!F:F"),"Y")))-IF(VLOOKUP(D16,D16:O16,3,FALSE)="Y",1,0)>0,TRUE,FALSE)...

Hi all I'm getting the above error on a new PC I'm setting up, it doesn't happen with the other PC's in use with the same code! With CreateObject("ADODB.Connection") .Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=K:\KKDB.accdb;" .Execute "INSERT INTO TestOpen...

I've done this before, but struggling with the details of how. I have created a default worksheet that opens when Excel starts stored in my XLSTART directory. I need to create a default worksheet so that when I insert a sheet, the new sheet is formatted as I intended. I have tried saving as a...

Hi Community, I need some help running a SQL statement to insert rows starting at Row #3 . The statement works and will insert records, but I can't get it to start inserting at Row #3 which is messing up the data that's being put into the Access Database. Any guidance? Public Sub ShiftSwap()...

Hi I wanted group several sheets and then insert a picture or shape in one sheet and hoping it will appear on all grouped sheets but when I group sheets, insert picture or shapes options are grayed out. Is that by design? Thank you.

This is probably an easy one for you gurus, but it has me stumped. What I want to do is search for the ! symbol. When it's found, insert a row above it and insert some text. Then go to the next occurrence of the ! symbol and repeat until the end. I created a macro that would do this, BUT, the...

Hi all, I'm having a real issue in regards to being able to insert data into a cell which has data validation on it. Basically I have have made a simple data validation rule. Only numbers between 0000000000-99999999999 can be written into the cell (or in column A). I have used Excel function –...

Hi Folks. I cannot seem to figure out how to approach this one. I am trying to sum integer values in array 'INSERT Tabbing Data-GIS'!$A$2:$BZ$5000 Where column header matches certain criteria, i.e. if 'INSERT Tabbing Data-GIS'!$A$1:$BZ$1 are all available columns, needs to match value in $C7...

Afternoon all; Hoping someone can help me with what im sure is a simple problem. I have an excel SS that has roughly 100 columns populated with data. However I need to insert a column starting with column D and then automatically inserting a new column every other column after that. E.g insert...

I was able to insert picture in the past in my comments through insert comment → fill effects → picture → insert picture. But not anymore: the system is spooling and it tells me that I can do it through "work offline". I click offline and nothing happens. Anyone experienced this? I have excel...

Hi All I know how to insert characters x spaces from left or right, but in my column have a list of email addresses.They are all completely different and vary in length an characters before and after the @ sign. As an example I would like to change fred@smith.com to fred-123@smith.com and...

I have code to insert a set image. Could someone tell me how to alter it so it can insert a custom image please? Sub cmdJakeSig() Dim shp As Shape Set shp = ThisWorkbook.Worksheets("sheet1").Shapes("textbox4") Sheets("Sheet2").Shapes("ImgJ").Copy Sheets("sheet1").Paste...

I need a way to insert a "." into a string 3 characters from the end. I have a list of emails but they do not have the period. Example someone@worldwidewebcom - Needs to add "." before the com There is a long list so either a formula or VBA is needed. Thanks, WC

Is there a way that I can insert a range of rows (18:35) from Sheet1 in between rows 17 & 18 in sheet2? Everything I have tried ends up replacing at least one row in the target sheet. I suppose I could insert the right number of rows and then overwrite them, but that's a double pain. I hope...

I have code that puts an image in the right spot. Could someone help me with the code that allows you to insert your own image and put it in the same spot please? This is the code that puts the set image in the right spot. Sub cmdGarrettSig() Dim shp As Shape Set shp =...

Is there a macro or vba code i can use so that when cell C6 dropdown is selected, a message box appears for the user to insert a comment mandatory? I would like to use this for multiple cells i.e. cell C6 dropdown 'Resource' is selected, message box appears saying 'Insert Comment'...user...

Hi all, I am just playing around with creating some pivot tables from VBA. I followed an online guide which worked perfectly when following his model, but has not worked when I tried to modify for my own purposes. Code is here: 'Declare VariablesDim PSheet As Worksheet Dim DSheet As Worksheet...

"insert into temp_cost(RecordID,ClassID, Classtype, ClassName, TypeOrder, CreateDate) values('" & strRecordID &"','"& strClassID &"','"& strClassType & "', '" & strClassName & "', '" & strTypeorder & "', '" & strCreateDate & "')" This code works, but I am trying to add a subquery to auto...

Hello, I am having an issue with inserting a row into my worksheet. I believe it's because I have two tables a few columns apart from each other. I say this because I was originally able to insert rows when there was only one table present. I have tested it and when I convert the second...

I have the current macro (Code below) that adds one record to an access database which works great. How do I create a loop that would insert all 500 rows and stops at the next blank cell? Or is there another option I should be looking at to insert multiple rows into access? Sub Add_Record()...