python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - excel

loop from (sheet.name) to (sheet.name)

how to loop through sheets, from (sheet.name) to ( sheet.name) and find(TextBox1.Value) , then Delete Entire Row that contain the (TextBox1.Value) the from (sheet.name) = TextBox2.Value the to ( shee...
test-img

ahmad

excel

vba

loops

Votes: 0

Answers: 1

Latest Answer

Use Select Case Option Explicit Private Sub cmdega_Click() Dim ws As Worksheet, rngFound As Range, rngDelete As Range Dim fromsheet As String, tosheet As String Dim id As String, fir...
test-img

CDP1802

Don't paste entire Column, only row based on x value

I want to copy the columns "Asset", "Quantity", "Market Value" and "Portfolio Weight %" and only up until the ClientStartRow & ClientEndRow I am aware that ...
test-img

John_C4439

excel

vba

excel-formula

Votes: 0

Answers: 1

Latest Answer

The reason cell.Range(ClientStartRow & ":" & ClientEndRow).Copy fails is because that line tries to specify the enitre row relative to cell. When cell is not in column A, that exte...
test-img

chris neilsen

Trying to build a case structure

I am trying to build a case structure using If/ElseIf statements, but I'm not sure what to dimension my "Region" variable to use a decision variable to be used later on. (Say later I want to...
test-img

WhiteTiger4

excel

vba

Votes: 0

Answers: 0

VBA - very slow macro execution on (theoretically) newer, better computer

I'm currently trying out Excel on Macbook Air M1 16/256, Office 365 version 2112 64-bit, run through Windows 11 Virtual Machine through Paralells. Excel itself, as well as other basic apps in Windows ...
test-img

sz17

excel

vba

virtual-machine

parallels

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs