vba &

  1. S

    range calculation in terms of distance

    guys i do need help for calculating range like no effect of terrain and anything. i need macro anything on my excel document to simultaneously calculate distance vs battery percentage .that is whenever it goes from 80% to 5% it will charge again means reset its counter and so on . my total range...
  2. A

    At a same time refresh all data connections in all open workbooks

    I have multiple workbooks and I want to refresh all data connections in all open workbooks for that I have given try to following vba code <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height...
  3. A

    Copy data from worksheet and paste in same worksheet but at different range

    I have some data points that are unique in each sheet and the same unique data points need to pasted as a value in the same worksheet but at different range I have write down following VBA code for copy paste in same sheet Sub EOD() Dim i AsLong For i =4To ThisWorkbook.Worksheets.Count...
  4. A

    Copy data from worksheet and paste in same worksheet but at different range

    I have some data points that are unique in each sheet and the same unique data points need to pasted as a value in the same worksheet but at different range I have write down following VBA code for copy paste in same sheet <code style="margin: 0px; padding: 0px; border: 0px; font-style...
  5. A

    object required error 424

    I have following vba code which throws error of object required error 424 please help me on this With Worksheets("OPTIONS").Activate.QueryTables.Add(Connection:= _ mystr, Destination:=ThisWorkbook.Worksheets("OPTIONS").Range("$A$1")) any help will be appriciated by word of thanks
  6. A

    When a cell value changes, copy the column from where the cell value changed to another sheet at the same range

    For example, if in the range of A:A cell A8 change then copy D4:I4 and paste it as value in another sheet named as "ADP" at the same place i.e. D4:I4 For that I have tried the following macro which requires some modifications, please suggest the same. any help greatly appriciated. thank you...
  7. V

    Excel VBA & Fill certain part of the Image based on cell value

    Hi all, Firstly thank you for taking the time to read my post.. My Question: I have an image that I want to put into into excel document and when a user completes a certain cell value corresponding to the part of the image it fills in the specific part of the image with that cell value. For...
  8. V

    Vba increase cell value by 5%

    Hi all, I was wondering if i could get your advice. Is there a way to automatically increase a numerical value in "column A" by 5% without having to add another column to do the calculation within VBA. I haven't come across any Google topics that can answer this question.
  9. J

    vba userform textbox numeric only

    Hello, Looking for the code to check a userform textbox to see if anything in it contains anything other than numbers. Basically textbox1 takes the input and finds the numbers, however if someone accidently inserts letter or special character instead of a number it messes my other code up. I...
  10. J

    HTML using VBA for body of email

    Hello, I am trying to insert HTML code for the first time in my VBA to help format the body with bold, font, number point, etc. I found a nifty site (https://www.quackit.com/html/online-html-editor/) that allows me to build what I want the email body to look like and then it gives me the HTML...
  11. J

    VBA userform textbox to textfile and back

    Hello, Stumped on this one. I have a userform with a textbox to input item number(s) and two option buttons "upload" and "retrieve". when the code is run I would like it to doe the following: If optionbutton1.value = true then I'd like it to take the item number(s) to be put into a textfile...
  12. M

    Lookup for some specific cells in all the sheet and write value in ne master sheet

    BELOW LINK (1) IS GIVEN FOR DETAILED EXPLANATION OF MY QUERY IN EXCEL SHEET (1) https://drive.google.com/open?id=1ZwLNu1g_kNJ9qJzzwZDunStWc0cKKlVN BELOW LINK (2) IS GIVEN FOR VBA CODING TO BE DONE IN WHICH EXCEL SHEET (2) https://drive.google.com/open?id=1k4ZKvnHwR_1yp2BHuB0yWMF4ewgLljZJ...
  13. V

    VBA to create same named folders by the excel file outputted with this code and move file into their folder

    Hi Experts, I need your guidance please. I was wodnering if anyone knows how i can enhance the below code to generate folders based on the output file name and move the output file into the folder that is created. - The code generates multiple excel files in the below format "Store...
  14. V

    VBA Row Header

    Good morning my peers, I was wondering if anyone could help with the below code. My row header is from row is from "A1:L1" however i need to have A:1 toL1 & subsequent rows to "A5 to L5" copied into the new tabs. can anyone help amend this beast? Sub MoveOnCondition() Dim DataSh As...
  15. V

    Advice on VBA Code

    I was wondering if i can get your expertise! Is there a code that anyone knows of that will do the following: 1. Split a workbook tabs into new separate workbooks. 2. Save each new workbook created as the original file name including with the tab name that has been moved into the new workbook...
  16. V

    Help with VBA code

    I was wondering if i could get your advice. I have the below code which works for copying and creating additional tabs by splitting values from a column into 2 tabs by applying a autofilter. However when it creates the 3rd tab it shows an error message that there is not enough memory to...
  17. C

    Look for column name in a sheet and calculate the sum and return in another sheet

    Hi I have been working with a excel file with lot of datas which is arranged in 2 sheets, So I would like to get datas from sheet 1 to sheet 2 with reference to the column headings. For example: <tbody> function1personA Function2personA Function1personB Function2PesonB crit1 crit1...
  18. J

    VBA Pivot: show/hide specific levels

    Hi all Been searching through high and low but haven't found what I was looking for. Perhaps someone here can help. Quite often I find my self in need of a macro that can hide/show details to a certain level for my Pivot Table in compact mode. It needs to be robust as it should work in various...
  19. B

    Validation to Give Suggestions on Error

    I have a workbook which requires the user to typein a county name. There is then a vlookup that returns the urban/rural designation based on that county name. I was wondering if there was a way, when the county name was entered incorrectly and results in an error, for a form to pop-up with...

Some videos you may like

This Week's Hot Topics