• Register

Recent questions tagged excel

1 vote
1 answer 7 views
0 votes
1 answer 7 views
How do you convert a numerical number to an Excel column name in C# without using automation getting the value directly from Excel.?
asked Aug 28 Aliza313 720 points
0 votes
1 answer 9 views
Problem: Currently I am trying to get my excel to copy every row which says either apple, berry or cherry for a previous month and then put them in my corresponding sheets. I have also tried some of the VBA code but I am also having a lot of trouble while making ... to search all of my sheet names rather than just the "apple". Also I am experiencing trouble while finding a last row with my data.
asked Aug 6 Raphael Pacheco 4.9k points
1 vote
2 answers 592 views
Problem : I am very new to VBA. Recently I was using VBA code to execute the solver. On executing my VBA code I am facing below error. Integer constraint cell reference must include only variable cells . I wanted my cells C87:K93 as integers but somehow my constraints ... ="0"    SolverOk SetCell:="$N$95", MaxMinVal:=1, ValueOf:="0", ByChange:="$C$87:$K$93"    SolverSolve UserFinish:=True End Sub
asked May 9 stewart 4k points
0 votes
2 answers 33 views
Problem: An Excel ____ allows data to be summarized and charted easily?
asked Apr 12 ArifulIslam 5.7k points
0 votes
2 answers 42 views
Problem: Can anyone give the right solution by filling in the blanks? A database is used instead of a spreadsheet when ________? A) lists of data involve a single theme B) structures of data lists are simple C) lists involve data with multiple themes D) users do not want to store all data in one place
asked Feb 23 maddi86 5.4k points
0 votes
1 answer 23 views
Problem: Does anybody realize how to rename a segment in google spreadsheets?
asked Feb 21 jennygotit 200 points
0 votes
1 answer 71 views
Problem : We have a few Windows Desktop Apps written in VB.2010 and VB.2017 that have been running for quite a while at numerous clients. At that point a week ago Tues, Nov 13, 2018 we began getting clients messages and considers saying the applications are getting a mistake 1004/ ... are real. I am certain this is a MS bug. Would someone be able to point me the correct way and ideally a MS fix?
asked Nov 29, 2019 alecxe 7.5k points
0 votes
1 answer 145 views
Problem : I am having the following error whenever I am trying to open Excel Online in Chrome, But Excel Online in Safari is working fine for me. Does anyone know how to fix this issue? Sign in Something went wrong and we can't sign you in ... . Please try again later. The Microsoft account login server has detected too many repeated authentication attempts. Please wait a moment and try again.
asked Nov 26, 2019 alecxe 7.5k points
0 votes
2 answers 181 views
Problem : Facing following C# selenium webdriver error while reading Excel Sheet. missing compiler required member 'microsoft.csharp.runtimebinder.csharpargumentinfo.create' And the code for reading excel is as below: excel.Application x1Appl = new excel.Application(); excel. ... \o\SearchBy.xlsx"); excel._Worksheet x1WorkSheet = x1WorkBook.Sheets[1]; Kindly let me know is there anything missing?
asked Nov 18, 2019 peterlaw 6.9k points
0 votes
1 answer 76 views
Problem : Need solution for bellow problem the cell reference for the merged cell is the upper-right cell reference.
asked Nov 7, 2019 peterlaw 6.9k points
To see more, click for the full list of questions or popular tags.