Questions about worksheet
Read more about worksheet
python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
vba types incompatible while comparing two strings
I want to compare two strings from two different worksheets with vba in excel. Already wrote the following code:
Public Sub Vergleich_Arbeitsmappen()
Dim i As Long
Dim projectCounter As Integer
Dim st...
tom
Votes: 0
Answers: 1
Change VBA code to work with protect worksheet
This code was kindly given by VBasic2008. It works very well with the unprotected worksheet but when i protect the worksheet, the code generates an error. I didn't mention the protected worksheet when...
Luis Lopes
Votes: 0
Answers: 0
How to fix code to save all worksheets as one PDF? VBA
'How to fix code to save all worksheets as one PDF from the open workbook? VBA. It only prints the active worksheet right now for some reason.
Sub abc()
For i = 1 To Workbook.Worksheets.Count
With Act...
borna
Votes: 0
Answers: 1
Conditional Hyperlink if Value from Sheet1 Matches Value in Sheet2
I would like to create a conditional hyperlink in Column A (Link) of Sheet 1 to a matched cell in Sheet 2 when a value in Column B (Number) of Sheet 1 matches that of Column A in Sheet 2 (Number).
I...
MissNG
Votes: 0
Answers: 2