$$Excel-Macros$$ Text +17273513812 XANAX, KUSH, LSD, ICE, WEED, OXYCODON, OXYTOCIN, MDMA, CRYSTAL METH. 

 One SOS  Gang : Serious buyers only   Wickr: baronmeds   Text +17273513812   text or Whatsapp: Plus 1 (seven seven four ) three two six four four Six two We are legit suppliers of Xanax, Oxytocin's, Lsd, Cocain, MDMA, Crystal met we also have few other medications like TKO

$$Excel-Macros$$ Fast Delivery, Exotic Top Shelf Flowers Carts And Oils

Signal:+1(929) 900-5143 High ~~~ Concentrates, Flower, And Carts Available Now! I currently have a variety of ~~~ shelf concentrates, flower, and vape cartridges available. We guarantee 100% satisfaction on all our products. All products are produced in a lab environment. We offer

$$Excel-Macros$$ Xanax pills, Oxycodone etc and marijuana strains

We can deliver to your door step the following .. Oxycontin 80 mg,Percocet 10/625mg,Diazepam Valium 10 mg,Xanax 2 mg,Suboxone 8 mg,Roxycodone 30 mg,Opana 10 mg,Mandrax(Quaalude) 300 mg,Hydrocodone 500 mg,Actavis Promethazine Codeine cough syrup,Ritalin 5 mg,Adderall 30 mg, For stoners,we have

$$Excel-Macros$$ Re: Introduce Yourself !!

Buy pharmaceuticals online We have hulks , Pecs , Oxy,Clr You can contact for more information at Text: +1 929 900 5143 Wickr:tonyandeson11 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

$$Excel-Macros$$ Buy Blues, Yellows and vals in Bulk.. Nextday and sameday

WELCOME TO GREENS PHARMACEUTICALS MEDS ONLINE MED STORE, CENTER OF ALL MEDICAL SOLUTIONS. GET SOLUTION FOR YOUR ILLNESS TODAY.Company Order Via Website :https://www.greenishpharma.com/ Customer Support CALL OR TEXT /WHATSAPP..+1 (929)-900-5143 Fentanyl brand name: duragesic 5-12 12.5 mcg/hr

$$Excel-Macros$$ Unsubscribing due to unsolicited emails

with in the past, feel free to hang onto my email address and contact me directly. I would enjoy keeping in touch. I'm sure you'll find me on other VBA help sites! Paul Schreiner -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official

Re: $$Excel-Macros$$ ETL Data Architect

At the bottom of each message, there is the address to use to unsubscribe. I'm nearly to the point of doing so myself...Really disappointed that the owner/moderator doesn't enforce the rules for the group (re: #5:)  Paul- “Do all the good you can, By all

Re: $$Excel-Macros$$ Preventing to Delete based on condition

I'm not sure how you implemented the code.If it is installed properly, the user cannot SELECT the entire row to delete! The code goes in the "Thisworkbook" module.you can add the line: Debug.Assert False to have it pause to see if the macro is actually being cal

$$Excel-Macros$$ SAP EHS candidate AVAILABLE immediately.

we have *SAP EHS *candidate AVAILABLE immediately. Please share open requirements. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

$$Excel-Macros$$ Certified SALESFORCE AVAILABLE IMMEDIATELY..

*Certified SALESFORCE AVAILABLE IMMEDIATELY.. * *Email us open requirements* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

$$Excel-Macros$$ SAP BASIS consultant open to relocate anywhere.

*SAP BASIS consultant open to relocate anywhere.* *Please share open requirements.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

$$Excel-Macros$$ HOTLIST - SALESFORCE / VMWARE / SAP EHS / SAP BASIS

HOTLIST - SALESFORCE / VMWARE / SAP EHS / SAP BASIS Name Primary Skill Location Availability Relocation B K - H1B Vmware Admin NJ Immediate Open B M - H1B Salesforce Dev/Admin NJ Immediate Open J M SAP EHS MI Immediate OPEN K J - H1B SAP BASIS Admin/Consultant HOUSTAN, TX Immediate OPEN R A - H1B

Re: $$Excel-Macros$$ Stop with the job postings!

I know!Right?I had them all blocked and something happened and now they all started getting through.I'm very close to unsubscribing from the list because of all of the job postings. One other sight that I used to participate in simply closed down completely because of the spam postings. Paul

$$Excel-Macros$$ Available VMWARE CONSULTANT immediately. Please review attached resume.

Available VMWARE CONSULTANT immediately. Please review attached resume. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate

$$Excel-Macros$$ Certified SALESFORCE AVAILABLE IMMEDIATELY..

*Certified SALESFORCE AVAILABLE IMMEDIATELY.. * *Email us open requirements* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

$$Excel-Macros$$ SAP EHS candidate AVAILABLE immediately.

we have *SAP EHS *candidate AVAILABLE immediately. Please share open requirements. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

$$Excel-Macros$$ SAP BASIS consultant open to relocate anywhere.

*SAP BASIS consultant open to relocate anywhere.* *Please share open requirements.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

$$Excel-Macros$$ HOTLIST - SALESFORCE / VMWARE / SAP EHS / SAP BASIS

HOTLIST - SALESFORCE / VMWARE / SAP EHS / SAP BASIS Name Primary Skill Location Availability Relocation B K - H1B Vmware Admin NJ Immediate Open B M - H1B Salesforce Dev/Admin NJ Immediate Open J M SAP EHS MI Immediate OPEN K J - H1B SAP BASIS Admin/Consultant HOUSTAN, TX Immediate OPEN R A - H1B

Re: $$Excel-Macros$$ Preventing to Delete based on condition

   End If     End If    Next TargEnd Sub Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as

$$Excel-Macros$$ SAP BASIS consultant open to relocate anywhere.

*SAP BASIS consultant open to relocate anywhere.* *Please share open requirements.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

$$Excel-Macros$$ SAP EHS candidate AVAILABLE immediately.

we have *SAP EHS *candidate AVAILABLE immediately. Please share open requirements. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

$$Excel-Macros$$ Certified SALESFORCE AVAILABLE IMMEDIATELY..

*Certified SALESFORCE AVAILABLE IMMEDIATELY.. * *Email us open requirements* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

$$Excel-Macros$$ HOTLIST - SALESFORCE / VMWARE / SAP EHS / SAP BASIS

HOTLIST - SALESFORCE / VMWARE / SAP EHS / SAP BASIS Name Primary Skill Location Availability Relocation B K - H1B Vmware Admin NJ Immediate Open B M - H1B Salesforce Dev/Admin NJ Immediate Open J M SAP EHS MI Immediate OPEN K J - H1B SAP BASIS Admin/Consultant HOUSTAN, TX Immediate OPEN R A - H1B

$$Excel-Macros$$ HOTLIST - SALESFORCE / VMWARE / SAP EHS / SAP BASIS

HOTLIST - SALESFORCE / VMWARE / SAP EHS / SAP BASIS Name Primary Skill Location Availability Relocation B K - H1B Vmware Admin NJ Immediate Open B M - H1B Salesforce Dev/Admin NJ Immediate Open J M SAP EHS MI Immediate OPEN K J - H1B SAP BASIS Admin/Consultant HOUSTAN, TX Immediate OPEN R A - H1B

$$Excel-Macros$$ HOTLIST - SALESFORCE / VMWARE / SAP EHS / SAP BASIS

HOTLIST - SALESFORCE / VMWARE / SAP EHS / SAP BASIS Name Primary Skill Location Availability Relocation B K - H1B Vmware Admin NJ Immediate Open B M - H1B Salesforce Dev/Admin NJ Immediate Open J M SAP EHS MI Immediate OPEN K J - H1B SAP BASIS Admin/Consultant HOUSTAN, TX Immediate OPEN R A - H1B

$$Excel-Macros$$ Certified SALESFORCE AVAILABLE IMMEDIATELY..

Certified SALESFORCE AVAILABLE IMMEDIATELY.. Email us open requirements -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate

$$Excel-Macros$$ Available VMWARE CONSULTANT immediately. Please review attached resume.

Available VMWARE CONSULTANT immediately. Please review attached resume. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate

$$Excel-Macros$$ HOTLIST - SALESFORCE / VMWARE / SAP EHS / SAP BASIS

HOTLIST - SALESFORCE / VMWARE / SAP EHS / SAP BASIS Name Primary Skill Location Availability Relocation B K - H1B Vmware Admin NJ Immediate Open B M - H1B Salesforce Dev/Admin NJ Immediate Open J M SAP EHS MI Immediate OPEN K J - H1B SAP BASIS Admin/Consultant HOUSTAN, TX Immediate OPEN R A - H1B

Re: $$Excel-Macros$$ Excel Formula : Duplicate values

You can use: =IF(AND(COUNTIFS(A:A,A2,B:B,"A")>0,COUNTIFS(A:A,A2,B:B,"B")>0),"Yes","No")  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At al

$$Excel-Macros$$ HOTLIST - SALESFORCE / VMWARE / SAP EHS / SAP BASIS

HOTLIST - SALESFORCE / VMWARE / SAP EHS / SAP BASIS Name Primary Skill Location Availability Relocation B K - H1B Vmware Admin NJ Immediate Open B M - H1B Salesforce Dev/Admin NJ Immediate Open J M SAP EHS MI Immediate OPEN K J - H1B SAP BASIS Admin/Consultant HOUSTAN, TX Immediate OPEN R A - H1B

$$Excel-Macros$$ HOTLIST - SALESFORCE / VMWARE / SAP

HOTLIST - SALESFORCE / VMWARE / SAP Name Primary Skill Location Availability Relocation B K - H1B Vmware Admin NJ Immediate Open B M - H1B Salesforce Dev/Admin NJ Immediate Open J M SAP EHS MI Immediate OPEN K J - H1B SAP BASIS Admin/Consultant HOUSTAN, TX Immediate OPEN R A - H1B SAP

$$Excel-Macros$$ HOTLIST - SALESFORCE / VMWARE / SAP

HOTLIST - SALESFORCE / VMWARE / SAP Name Primary Skill Location Availability Relocation B K - H1B Vmware Admin NJ Immediate Open B M - H1B Salesforce Dev/Admin NJ Immediate Open J M SAP EHS MI Immediate OPEN K J - H1B SAP BASIS Admin/Consultant HOUSTAN, TX Immediate OPEN R A - H1B SAP

$$Excel-Macros$$ Please add on linkedin - https://www.linkedin.com/in/praful-sharma-6b12b7169/

https://www.linkedin.com/in/praful-sharma-6b12b7169/ -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor

$$Excel-Macros$$ HOTLIST - SALESFORCE / VMWARE / AWS / SAP

HOTLIST - SALESFORCE / VMWARE / AWS / SAP Name Primary Skill Location Availability Relocation B K - H1B Vmware Admin NJ Immediate Open B M - H1B Salesforce Dev/Admin NJ Immediate Open L V - H1B AWS Engineer CA Immediate Open J M SAP EHS MI Immediate OPEN K J - H1B SAP BASIS Admin/Consultant

$$Excel-Macros$$ ActiveX ComboBox (Worksheet object) triggering unexpected behaviour

I have some code I've written that, until I added a ComboBox (worksheet ActiveX object), worked fine. This is the code that triggers the problem (all it does is put the current date into a cell): Range("PolicyStartDate").Value = Format(Now(), "dd-mmm-") When this line executes, the

Re: $$Excel-Macros$$ Re: Need Help in IF formula

the formula seems to work as it is designed.So what kind of help do you need?  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever

Re: $$Excel-Macros$$ macros won't run as written

What does your macro look like? I recorded a macro, then "cleaned it up".the result being: Sub PageFormat     ActiveSheet.PageSetup.LeftFooter = ""     ActiveSheet.PageSetup.RightFooter = "" End Sub it seems to work great in Excel 2010 Paul

Re: $$Excel-Macros$$ Need VBA or VBS scripting codes

Yes... that's what this group is for! If you tell us what the issue is what you've done so far, there's lots of us available to help! Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all

Re: $$Excel-Macros$$ Urgent !!! Urgent !!! Urgent !!! Vba code required !!! To copy from another workbook to the current/active workbook

ssroom assignment that you're hoping that this forum may be used to complete? If so, I'm sure someone here would be willing to help you work through how to accomplish the assignment rather than simply do the assignment for you. sorry if I've spent time I COULD'VE used to write code but instead v

Re: $$Excel-Macros$$ Delete some rows from Excel as per condition

I looked in your attached macro module and do not see where you included the loop to delete rows by year. Can you send me some sample data as well so I can test/debug the macro you're using? Paul- “Do all the good you can, By all the means you can, In all

Re: $$Excel-Macros$$

lls(nRow, "A").Value     Next inx     Next nRow End Sub  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long a

Re: $$Excel-Macros$$

;fill one number 10 times"What does that mean? Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long a

Re: $$Excel-Macros$$ Delete some rows from Excel as per condition

on.ScreenUpdating = True     Application.StatusBar = False     MsgBox "finished" End Sub Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can

Re: $$Excel-Macros$$ Power BI

I've never heard of it, but:A) This is a site for Excel macros, not "Power Bi"  B) a Google search took me to the Microsoft site: https://powerbi.microsoft.com/ that has guided learning. Google also indicated YouTube channels and more("Power Bi tutorial" has over 1

Re: $$Excel-Macros$$ Lookup variable sheet name

Are you trying to look up the date from J1? If so, wouldn't it be:=VLOOKUP($J$1,INDIRECT("'"&"'!"&"$A$3:$F$3"),5,0) and, I'd suggest changing $F$3 to something like $F$1000 Paul- “Do all the good you can, By all the

Re: $$Excel-Macros$$ CODE FOR RANGE

to start the loop at row 12, simply change the iCntr to 12: iCntr = 12 Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the peo

Re: $$Excel-Macros$$ Date Generation !!!

he previous row:Cells(nRow, "B").Value = Cells(nRow - 1, "B").Value + 1 If you want to make the whole thing "dynamic", you'll have to decide how you want to determine the number of rows to process in the loop. But otherwise, it's pretty simple. Paul---

Re: $$Excel-Macros$$ Date Generation !!!

You could use a simple formula in column B, starting in B2 with:=IF(A2<>"",A2,B1+1) and copied down. Excel automatically calculates the next date and considers leap years when doing so. Paul- “Do all the good you can, By all the means

Re: $$Excel-Macros$$ Excel Macro Help

sure.fairly easily done.Please provide sample files.  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley

Re: $$Excel-Macros$$ Formula for Month wise calculation

1,1,1),H$2-DATE(YEAR(NOW())-1,1,1)) -MAX(DATE(YEAR(NOW())+1,1,1)-$C3,DATE(YEAR(NOW())+1,1,1)-DATEVALUE(MONTH(H$2+31)&"/1/"(H$2+31))),0) +IF(AND(MONTH($C3)=MONTH(H$2),YEAR($C3)=YEAR(H$2)),1,0) hope this helps Paul- “Do all the good you can, By all the mean

Re: $$Excel-Macros$$ reconiling large data in excel

s what you're trying to accomplish with "reconciling" the data is not possible. Please provide an example of what results you're trying to achieve. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places

Re: $$Excel-Macros$$ Extract data in svg file and store automatically in excel

SVG files are in XML format.In the past, I've used Excel VBA to open XML files as a "text stream" and parsed out the data to extract data.  If you can send me a sample file and tell me what you're looking for "model number" and what values you expect to extract, I can see what I can do to

Re: $$Excel-Macros$$ Help on Week Formula

f so, what is the minimum number of days counted in a week 1? Or are you wanting a simple count of days:Week 1 = first 7 daysWeek 2 = Second 7 daysetc.  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you c

Re: $$Excel-Macros$$ Macro Error in line. .

step through it and watch what happens to Dirpath.I also like to add a "Watch" of:Err.Number & ": " & Err.Description (with scope of "all modules") so that I can see if an error is being caught but not halting due to the "On Error Resume Next" statement. Pau

Re: $$Excel-Macros$$ Find out the value of the cell based on row and column

use:=INDIRECT(E3) Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley

Re: Fwd: $$Excel-Macros$$ for multiple condition to calculate A SIMPLE RESULT

t;),(F2+K2)*0.05, "other"))  I'm not sure what you mean by:"FOR THE OTHER PERSONS IT TAKES OTHER CALCULATION AL WELL" do you mean "AS WELL", meaning that other combinations have alternate calculations? If so, you can add the appropriate

Re: $$Excel-Macros$$ Urgent Opening for Ab-initio with AWS JAVA back ground : Richmond VA

a company that cannot be bothered to follow the rules... Just an observation... Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can

$$Excel-Macros$$ Urgent Opening for Ab-initio with AWS JAVA back ground : Richmond VA

· Work involves transferring from DDE to AWS using Ab Initio – Need candidates with strong Ab Initio background with java skills · Need folks with AWS knowledge with scripting to create infrastructure, should have Java background *Kamal Paul* *Technical Recruiter* (Desk):610-590

$$Excel-Macros$$ Re: Introduce Yourself !!

HI , My name is kamal paul working as an US IT recruiter at Zodiac -solutions. On Saturday, June 9, 2012 at 12:51:59 AM UTC+5:30, Ayush Jain wrote: > > Hey all new and current posters, > > Welcome to excel group,one of the largest online community of excel Fans! > > I h

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

If you can give me a larger sample of data, I can try to work on something.Since it sounds like you have no background with VBA programming, I'll try to develop an Excel-Function solution.  Paul- “Do all the good you can, By all the means you can, In all

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

the layout changes, while it is a cumbersome layout, it ought to be possible to write a macro that searches through the data and collects the data.  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you c

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

That didn't answer my questions. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

There's not enough information for me to guess how you want the summary populated. How "dynamic" is your data?Is the number of Products variable or fixed?is the number of Customers variable or fixed?   Paul- “Do all the good you can, By all the

Re: $$Excel-Macros$$ Re: Custom Formatting in Excel

No, I just wan to retain value upto 10 decimal in excel cell but to display lowest whole no irrespective of value after decimal points > or <=.5 On Sun, Jun 18, 2017 at 9:41 AM, GENIUS wrote: > look at the sheet, may be you required this. > > -- > Are you =EXP(E:RT) or

$$Excel-Macros$$ Custom Formatting in Excel

Hi Champs, I am sharing excel File; where a value 41726.8901269684 is stored in cell. I want to display only 41726 using Custom Formatting while retaining same value in that cell irrespective of decimal part > or < .5 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Required fastest vlookup formula

I have previously dealt with similar situations. In one case, I have an application that has over  164,000 rows and 74 columns.Frequently, queries and reports retrieve records based on multiple columns. VLOOKUP became much too time consuming, but due to the volatile nature of the data,

Re: $$Excel-Macros$$ simple macro??

range: "...in a column and name the range "Input""? Op dinsdag 6 juni 2017 18:25:43 UTC+2 schreef Paul Schreiner: You're saying that F77 is a calculation that uses the value of F5.You want to  change F5 from 1 to 100 and do WHAT with the resulting value in F77? Are you saying tha

Re: $$Excel-Macros$$ simple macro??

You're saying that F77 is a calculation that uses the value of F5.You want to  change F5 from 1 to 100 and do WHAT with the resulting value in F77? Are you saying that you want to simply put 1-100 in one column and then show in an adjacent column the result when this number is put into F5? Is the

Re: $$Excel-Macros$$ Stop the code from Running when Selecting Row

quot;) Now, to your question. If you select an entire row, Target.Count will be a count of all the cells in the row.For Excel 2007 and beyond, that is 256. So, you COULD add: If (Target.Count > 100) then exit sub Paul- “Do all the good you can, By all the

Re: $$Excel-Macros$$ why excel is slow when we run macro

clipboard before pasting it to the new cell. So.. what you mean by "excel is slow" and "when we run macros"... could have LOTS of meanings.  It's going to depend on your specific situation. if you want to send me the file, I'd be glad to take a look and see if I can fig

Re: $$Excel-Macros$$ Need Help please - Type Mismatch on rows insert macro

Let's say that you have 100 rows of data. "bottom" ends up being 100.so your Rows statement results in:Rows(R:100).insert shift:=xldown I think it needs to beRows(100:100).insert shift:=xldown so you'd use:Rows(r & ":" & r).Insert Shift:=xlDown Paul-

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

;A").Value     ActiveSheet.Cells(dRow, dCol + 1).Value = ActiveSheet.Cells(3, rCell.Column).Value     Next nCnt     End If     Next rCell     MsgBox "Finished" End Sub  Paul- “Do all the good you can, By all the means you c

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

first knowing where you started and what options are available to get from the start to the end.Lots of options are AVAILABLE, but if your starting point is two streets away, the use of an airplane is unlikely. Teleportation is WAY cooler, and should remain in consideration for that re

Re: $$Excel-Macros$$ Links

books.Open line. the line should read:On Error Goto 0 or maybe put it right BEFORE the workbooks.Open line, so you know if it fails.  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the

Re: $$Excel-Macros$$ Links

    Else     ThisWorkbook.Sheets(1).Cells(nRow, "D").Value = "'" & Rng.Formula     End Ifputs the listing on the first sheet of the workbook. Paul- “Do all the good you can, By all the means y

Re: $$Excel-Macros$$ Links

quot;) > 0) Then     ThisWorkbook.Sheets(1).Cells(nRow, "C").Value = "'" & Rng.Formula     Else     ThisWorkbook.Sheets(1).Cells(nRow, "D").Value = "'" & Rng.Formula     End If     End If     Next Rng     Next S

Re: $$Excel-Macros$$ Links

the macro I suggested). It would take me at least an hour to TRY to create a file set that MIGHT duplicate your structure. Is it at all possible for you to send me the workbook directly (schreiner_p...@att.net)? If not, can you send me the macro you're using that is causing the pro

Re: $$Excel-Macros$$ Need help in Vba Macro

100,000 cells with the contents immediately. what does your code look like, and what do you mean that it "the code is not working"? Is it not removing the links?is it giving you an error?  Paul- “Do all the good you can, By all the means you can, In al

Re: $$Excel-Macros$$ Need help in Vba Macro

nd 100 columns. (so 100,000 cell contents)I then created a sheet that had 100,000 cells that added the contents of the adjacent sheet. This macro converted the 100,000 cells to values in about 3 seconds. Paul- “Do all the good you can, By all the means you

Re: $$Excel-Macros$$ Need help in Vba Macro

to the links to worksheets within the current workbook. does that help? Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can

Re: $$Excel-Macros$$ Links

UBound(alinks)     End If You can loop through the array to list unique values.  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever yo

Re: $$Excel-Macros$$ Count uniques with only 1 criteria column

n do something similar using VBA...Which approach do you want to take? Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.”

$$Excel-Macros$$ Excel VBA Sharepoint checkout-checkin

after the end of my shift for 3 hours on ONE DAY to migrate the data (or come in 3 hours early). but I'd prefer to be able to run a macro that does it all... does anyone have any experience with the VBA .CheckIN method for SharePoint? Thank you, Paul -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

Re: $$Excel-Macros$$ how to process parallel ranges with 'for each'

de the row/column offsets in the loop. Or, you could calculate the offset from the first cell of the rangeand use the offset in the second range. if you can give me some real-life examples, I could try to throw something together. Paul- “Do all the go

Re: $$Excel-Macros$$ Hide & lock a formula in the cell

The steps would be:1) Select all cells   Right-Click and select "Format Cells"   go to "Protection" tab and make sure "Locked" is selected.   Select "OK"2) Select all cells you want to be able to select/change   Right-click and select "Format Cells"   on "Protection" tab, DE-SELECT the "Locked"

Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB

pdate_Comments function does things like:- Clears the comments from cells that are blank- Shows a message if a value is entered that is not in the Dictionary hope this gives you something to work from. Paul- “Do all the good you can, By all the means

Re: $$Excel-Macros$$ What is dictionary object in vba, how do we use it?

   Dict_name.item(cells(nRow,"A").value) = dict_name.item(cells(nRow,"A").value) + 1 once you've cycled through the values, you can "look up" the total by using the .item method (above) Or you can convert the dictionary to an array by using: dArray = dict_name.keys lots of possibi

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----- On Sunday, March 12, 2017 1:23 AM, Sunil Kumar Yadav <

Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month

id that for your second question (rounding values to .5 increments)can be done with: =INT(A23*2)/2 My explanations get kind-of long, because I prefer to TEACH the reasons why instead of simply handing over answers.  Paul- “Do all the good you can, By all t

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

eginning and one at the end instead of inside each if/else statement. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the peopl

Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month

accomplish this by first doubling the number and removing the decimal portion(extract just the integer portion)then divide it by 2:=INT(A23*2)/2 this works for your samples. hope this helps.  Paul- “Do all the good you can, By all the means you can, In all t

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

on when protecting the sheet. I think it "SOUNDS" like you want to accomplish your other items using Excel functions rather than VBA.(however, VBA is ALWAYS an option) But it would be a LOT easier for both of us if you could share a sample file(even with "dummy" data) I'd b

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

ach cell in the target array like: dim Targ as rangefor each Targ in Target... (replace each occurrence of "Target" with "Targ") ...Next Targ Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the

Re: $$Excel-Macros$$ Re: same name

THAT what you're looking to do?(because that's what you asked) BTW: you changed BhaVani to BhaWani Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people yo

Re: $$Excel-Macros$$ to add - sign in vehical number

, then copy/paste Values to convert it to a value. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever

Re: $$Excel-Macros$$ Counting up the combinations

ults(qNo, qVal) = Results(qNo, qVal) + 1     Next nRow         For qNo = 1 To 4     For qVal = 1 To 5     Cells(qNo + 1, qVal + 6).Value = Results(qNo, qVal)     Next qVal     Next qNo     MsgBox "Fin" End Sub  Paul- “Do all the good you

Re: $$Excel-Macros$$ Counting up the combinations

to run! If you have to open each survey separately, it will take significantly longer :) let me know if you need additional assistance. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all

Re: $$Excel-Macros$$ keep active in memory variables, array variables

stance, you don't know what size they will be until run-time,you can declare the variable like: Dim sArray then, once you decide on a size, you can re-dimension it: ReDim sArray(nRow) Preserve Use the VBA help to read up on declaring arrays. hope this helps. Paul

Re: $$Excel-Macros$$ Formula help needed

nt row.You can then copy this function to the rows in column C and D. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - J

Re: $$Excel-Macros$$ about conversion of excel to text file.

lumn,then you're going to need a VBA macro to accomplish this. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can

  1   2   3   4   5   6   7   8   9   10   >