Recent questions tagged Excel

0 votes

685 views

1 answer

excel - Making VBA Form TextBox accept Numbers only (including +, - and .)

I have simple textBox and I want to validate its input including "+" , "-" and "." here is what I ... negative, positive value or float value.. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

637 views

1 answer

excel - Sum function in VBA

I have a problem with summing cells in vba. I need to use Cells(a,b): Range("A1").function="=SUM(Range(Cells(2,1 ... ,2)))" but it doesn't work. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

657 views

1 answer

excel - Three Dimensional Lookup Using INDEX/MATCH

This was taken and improved slightly from Question that has since been deleted For those who can see deleted posts ... has a better solution. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

553 views

1 answer

excel - How to find Number of Occurences of Slash from a strings

How can I find the number of occurrences of the forward slash character ( / ) within a string using an Excel VBA macro? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

535 views

1 answer

excel - Using the value in a cell as a cell reference in a formula?

I'd like to know how to pull cell references from the value of another cell and insert them into a formula. ... info on it. Thanks in advance. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

excel vba freeze pane without select

I have a VBA script in Excel that freezes the panes of an Excel worksheet, but I'm curious to see ... .FreezePanes = True Any suggestions? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

717 views

1 answer

excel - the file you are trying to open is in a different format than specified by the file extension in Asp.Net

the file you are trying to open is in a different format than specified by the file extension c# error when trying ... want this msg to appear. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

876 views

1 answer

excel - Cannot run the macro... the macro may not be available in this workbook

I am trying to call a sub on a different worksheet but I got a run time error message. Specifically, I ... .PreparetheTables" but did not work. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

540 views

1 answer

excel - Get length of array?

I'm trying to get the length of an array, yet I keep getting this error: Object required Am I doing ... columns.Length ' Error: Object required See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

708 views

1 answer

excel - VBA using ubound on a multidimensional array

Ubound can return the max index value of an array, but in a multidimensional array, how would I specify WHICH ... I have Ubound return 3? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

709 views

1 answer

excel - How to continue the code on the next line in VBA

I would like to type the mathematical forumla in VBA code which many lines. I would like to split it into many ... Need some guidance on this.. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

802 views

1 answer

excel - How to write/update data into cells of existing XLSX workbook using xlsxwriter in python

I am able to write into new xlsx workbook using import xlsxwriter def write_column(csvlist): workbook = ... xlswriter or any alternative. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

695 views

1 answer

excel - Break out of a While...Wend loop

I am using a While...Wend loop of VBA. Dim count as Integer While True count=count+1 If count = 10 Then ... like `While count<=10...Wend See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

773 views

1 answer

excel - How to know if a cell has an error in the formula in C#

In an Excel formula you can use =ISERR(A1) or =ISERROR(A1) In a VBA macro you can use IsError(sheet.Cells ... function in the API for that? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

795 views

1 answer

excel - Leave out quotes when copying from cell

Problem: When copying a cell from Excel outside of the program, double-quotes are added automatically. Details: I ... is copied to clipboard? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

572 views

1 answer

excel - Extract Data from PDF and Add to Worksheet

I am trying to extract the data from a PDF document into a worksheet. The PDFs show and text can be manually ... myPath = Dir Loop Next fCell See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

556 views

1 answer

excel - VBA nesting loops to calculate multiple employee hours

I have been working on getting a timesheet macro that will take a data dumps and make do a few things. Ultimately I am not familiar ... the value of the sum r = r + 1 Loop End Sub...

asked Jan 29, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags