Welcome to Jonic Developer Community for programmer and developer-Open, Learning and Share
Login
Remember
Register
Ask
Q&A
All Activity
Hot!
Unanswered
Tags
Categories
Users
Ask a Question
Ask a Question
Categories
All categories
Topic[话题] (13)
Life[生活] (4)
Technique[技术] (2.1m)
Idea[创意] (3)
Jobs[工作] (2)
Others[杂七杂八] (18)
Code Example[编程示例] (0)
Recent questions tagged excel
0
votes
1.3k
views
1
answer
excel - Copy Paste macro is inducing 'grouped'-worksheet functionality?
I am getting an error I can't figure out: After I run the macro below, two certain string values are pasted into the same two cells in ALL sheets, although ... = (item_a & item_b) End If End If End Sub See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
2.0k
views
1
answer
excel - Using Indirect function in Data Validation through VBA
I am using the indirect function in my excel sheet through VBA , I am getting an error when I try to substitute the cell address in. =indirect(F5) I ... = "" .ShowInput = True .ShowError = True End With See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.8k
views
1
answer
excel - vba: test if shape contains a textframe
I want to loop over all shapes in a chart in an excel file. This works in principle with Dim currChart As Chart Set currChart = Sheets("Diagramm 1") Dim ... a shape has a textframe. How can I do that? See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.5k
views
1
answer
excel - Finding highest and subsequent values in a range
I have the below code which is supposed to find the 1st, 2nd, 3rd, and 4th highest values in a range. It is currently very basic, and I have ... MsgBox "Fourth Highest Value is " & fourthVal End Sub See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.8k
views
1
answer
excel - VBA selecting visible cells after filtering
The following code applies filters and selects the top 10 items in column B after some filters are applied to the table. I have been using ... ").PasteSpecial Worksheets("OLD_Master").ShowAllData End Sub See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.6k
views
1
answer
excel - "Application.Calculation = xlCalculationManual" statement causing run-time error 1004 in VBA Copy-Paste procedure
I have VBA code that copies the first row and pastes the values to multiple rows. The below code runs fine and pastes the rows as expected: Sub ... range to lose focus, but does clear the clipboard. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.9k
views
1
answer
excel - How to choose specific SAP GUI session?
I am trying to run an Excel VBA code which uses SAP GUI Scripting. I have some open sessions in Sap and using two systems "F6P" and "FVP" at the ... /bopin" Session.findById("wnd[0]").sendVKey 0 End Sub See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.5k
views
1
answer
excel 2010 - Creating Calculated Field with SUM and COUNT of Fields Pivot Table
Here's a snapshot of my pivot table. I want to create a calculated field that displays the percentage from the Responded column (C) over the Ticket # ... calculated field that gives me the % in column G? See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.8k
views
1
answer
excel - Get the value of a textbox to a cell
I have a textbox called TextBox 1 which contains paragraphs. I defined it with a name (Insert > Name > Define...) called profile_reference. On a cell, I ... value of that textbox to a cell then parse it. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.8k
views
1
answer
excel vba - How to get the Day Name of Date?
I have a small code that gets the Day Name of the Dates listed in Excel. But the problem is, it's not getting the right Day Name(e.g. Tuesday). ... 's supposed to be "Tuesday". Thanks for the help guys. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
2.1k
views
1
answer
excel - Get the selected value of a activex combobox using vba
How do i get the selected value of the combobox? i have a combobox which has the values: "Corporate" and "Consumer". I want to get the value that i ... a = combobox.value; (a -> Consumer) thank you See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.6k
views
1
answer
excel - Programatically inserting click event code for dynamically generated label not working
I am inserting a ActiveX control Label in excel sheet using VBA code. Now after inserting the button, I am trying to insert the click event code but its ... there is an error. Any help? Thanks in advance. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.9k
views
1
answer
excel - openxlsx not able to read from .xlsx file in R
I am trying to read value from a .xlsx file using openxlsx package in R. In simple words, I need to write a row of data, which then populates some ... option I have due to JAVA errors from XLConnect etc. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.5k
views
1
answer
excel - When to use range.value?
If I'm reading/writing to a range, when do I just use the range name and when do I need to use range.value? Does it matter if the range is one cell or ... Range("Test") = a or Range("Test").value = a? See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.8k
views
1
answer
excel - Read XML Attribute VBA
I am trying to get the attribute of a single node in VBA, but can't manage it using DOM The XML looks like following: <?xml version="1.0" ... value of the ID attribute. Any help would be appreciated. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.5k
views
1
answer
excel - Detecting changes to checkboxes via VBA
Following on from my previous question. A requirement from the customer is to have checkboxes on a report to disable rows of information on another sheet. ... change in a checkbox with a sub/function? See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
2.1k
views
1
answer
excel - How to VBA sends an Async XMLHTTP request?
To get data from a webservice in Excel, I have created an excel addin provide function to get it; user just need type in cell: =sendRequest("http ... send request and get return value under async method. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.9k
views
1
answer
excel vba IE clicking a button
Through Excel and VBA, i am opening a page. I want to click on the button 'Expand' through vba but I am getting an error. I tried using both VBA ... '438': Object doesn't support this property or method. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
2.1k
views
1
answer
excel - VBA: Autofilter for Partial Array strings
I need to filter a column for the array I've made. I'm trying to use Cells.AutoFilter Field:=14, Criteria1:=stringArray, Operator:= but I don't ... xlFilterValues Is there a better way to do this? Thanks. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.5k
views
1
answer
excel - Working macro returns error when run from form control
I'm trying to move all charts from source sheet to destination sheet. The following code works fine when I run it from the VB Editor. My source had ... is not valid for the current chart type error. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
2.0k
views
1
answer
excel - SpecialCells(xlCellTypeVisible) also includes hidden/filtered cells
I have a dataset that I'm using a filter on. I simply want to calculate the total values in column N, that are visible. The data ... isn't SpecialCells(xlCellTypeVisible) working correctly in the macro? See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.9k
views
1
answer
excel - Importing .xls to Access .mdb: External Table is not in the expected format
I have a macro that imports a spreadsheet as follows: (this spreadsheet is an export from a web-based application, and during the initial export the ... the initial export from the web-based application? See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.6k
views
1
answer
excel - Webscrape loop on all URLs in Column A
I'm trying to scrape the Facebook Video Titles from a list of URL's. I've got my macro working for a single video in which the URL is built ... .innerText appIE.Quit Set appIE = Nothing End With End Sub See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.4k
views
1
answer
excel - Detecting duplicates formatted as text
I need a function to detect duplicates formatted as text. This cannot distinguish between "46.500" and"46.5000". CountIf probably compares cells as numbers. ... other way to check for duplicates in VBA? See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.6k
views
1
answer
excel - Using the Find VBA function with Defined String
Hey maybe I'm not seeing something obvious here but how can you use the Find VBA function with a predefined variable. I'm using a concatenation of ... With block variable not set" Any throughts, Thanks See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.5k
views
1
answer
excel - Vba loop for many sheets
I have vba code that adds calculations for 4 sheets. I want a loop that will calculate hundreds of sheet without adding sheetname again & again in code. Private ... -1])" End Sub Thank you for your help. See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.5k
views
1
answer
excel - How do you merge same value columns using vba?
Can anyone help me write a vba code to merge same value cells in different columns as shown below. I have tried using the code below but doesn' ... cr End With Application.DisplayAlerts = True End Sub See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
0
votes
1.7k
views
1
answer
excel - VBA Goalseek with Variable instead of Cell
I need to use Goalseek in my VBA code, but rather than seeking a goal for a target "CELL" in my spreadsheet, I need to seek a goal for a "VARIABLE" ... , to the "By changing" field. Is that even possible? See Question&Answers more detail:os...
asked
Oct 24, 2021
in
Technique[技术]
by
深蓝
(
71.8m
points)
excel
Page:
1
2
3
4
5
6
...
61
next »
Ask a question:
Welcome to Jonic Developer Community for programmer and developer-Open, Learning and Share
Just Browsing Browsing
[1] vue3如何加载远程字符串形式的组件?
[2] Powershell: Get-ChildItem performance to deal with bulk files
[3] javascript - Dictionary returns undefined when searching by key
[4] vue, uni app如何在任意一个js文件获取store或者globalData
[5] model - How to use VGG19 transfer learning pretraining
[6] 如何使用mongodb去实现一个递归累加的效果
[7] javascript - RxJS. Combine observables that emit less then 1 second apart
[8] Need to convert an Excel formula to a Google Sheet formula
[9] python - Django correct list using article_id
[10] python使用布尔值判断闰年出错
548k
questions
547k
answers
4
comments
55.4k
users
Most popular tags
javascript
python
c#
java
How
android
c++
php
ios
html
sql
r
c
node.js
.net
iphone
asp.net
css
reactjs
jquery
ruby
What
Android
objective
mysql
linux
Is
git
Python
windows
Why
regex
angular
swift
amazon
excel
algorithm
macos
Java
visual
how
bash
Can
multithreading
PHP
Using
scala
angularjs
typescript
apache
spring
performance
postgresql
database
flutter
json
rust
arrays
C#
dart
vba
django
wpf
xml
vue.js
In
go
Get
google
jQuery
xcode
jsf
http
Google
mongodb
string
shell
oop
powershell
SQL
C++
security
assembly
docker
Javascript
Android:
Does
haskell
Convert
azure
debugging
delphi
vb.net
Spring
datetime
pandas
oracle
math
Django
联盟问答网站-Union QA website
Xstack问答社区
生活宝问答社区
OverStack问答社区
Ostack问答社区
在这了问答社区
在哪了问答社区
Xstack问答社区
无极谷问答社区
TouSu问答社区
SQlite问答社区
Qi-U问答社区
MLink问答社区
Jonic问答社区
Jike问答社区
16892问答社区
Vigges问答社区
55276问答社区
OGeek问答社区
深圳家问答社区
深圳家问答社区
深圳家问答社区
Vigges问答社区
Vigges问答社区
在这了问答社区
DevDocs API Documentations
Xstack问答社区
生活宝问答社区
OverStack问答社区
Ostack问答社区
在这了问答社区
在哪了问答社区
Xstack问答社区
无极谷问答社区
TouSu问答社区
SQlite问答社区
Qi-U问答社区
MLink问答社区
Jonic问答社区
Jike问答社区
16892问答社区
Vigges问答社区
55276问答社区
OGeek问答社区
深圳家问答社区
深圳家问答社区
深圳家问答社区
Vigges问答社区
Vigges问答社区
在这了问答社区
在这了问答社区
DevDocs API Documentations
Xstack问答社区
生活宝问答社区
OverStack问答社区
Ostack问答社区
在这了问答社区
在哪了问答社区
Xstack问答社区
无极谷问答社区
TouSu问答社区
SQlite问答社区
Qi-U问答社区
MLink问答社区
Jonic问答社区
Jike问答社区
16892问答社区
Vigges问答社区
55276问答社区
OGeek问答社区
深圳家问答社区
深圳家问答社区
深圳家问答社区
Vigges问答社区
Vigges问答社区
在这了问答社区
DevDocs API Documentations
广告位招租
...