properly

I made a spreadsheet for a client, It has lots of formulas and linking between worksheet (65 to be exact). There is only 2 fields in each sheet that I want the client to be able to enter information in which will then calculate things properly based on the formulas ect. So my questions is...

Hello, I have a little problem. I have a large statistic table in one WB and in a different WB references to the first one. When I open my second WB i see #ARG ! in every cell, but when I open both the values are displaying properly. Can I somehow fix it so that values would be correct if...

i have some data in Output and Input sheets my intention to use xlsheetveryhidden for both sheets,because user not required to see both sheets but this sheet is interlinked to another sheets if this sheets are "xlsheetveryhidden" my macro is not running properly if they are visible my code...

I am currently using Excel 2010 VBA to copy a worksheet containing an image from one workbook to the other. The image of the copied worksheet, however, cannot be properly displayed and an error "This image cannot currently be displayed" appear in the image placeholder instead. After a bit of...

Hello, I'm trying to make my first array and hitting a snag. I'm making a macro that automatically runs upon opening any Excel file. I'm having a runtime error of 438, Object doesn't support this property or method. I feel it's from incorrectly defining my active sheet. How would I properly do...

Hey All! Was hopping you could help me really quick! My boss asked me to compare two worksheets with very similar data, and find the variences. I know vlookup is my best bet here, but I haven't used it in a while and I can't get it to work properly. Please help - she needs this by EOD! The...

hi.. i wanna know how can i have table and charts of a sheet Full screened and FITTED (in every size of monitors ) when i click on the button1 .. i have used this code but it didn't work properly ActiveSheet.UsedRange.Select ActiveSheet.ChartObjects.Select Application.DisplayFullScreen = True...

Anyone know how to webscrape this site properly? Greyhound Bet | Greyhound Betting Web App from the Racing Post Many thanks

Assalam u Alikum I have used smart filter in my power bi desktop report, now problem is that it is not working properly when I am searching and selecting the employee id in that filter it auto deselect that id in a glimpse and if it select the employee id it not do filter the information...