logo
down
shadow

EXCEL-VBA QUESTIONS

get data from previous sheets
get data from previous sheets
Hope that helps Your problem was that you were always storing in column H a value created by taking the value from column F of the current sheet and appending the value from column F of the sheet being processed within the loop. When you move to the
TAG : excel-vba
Date : November 19 2020, 11:01 PM , By : rubydriver2
Excel macro to export the test cases along with the associated requirement Ids
Excel macro to export the test cases along with the associated requirement Ids
will be helpful for those in need Since a test can cover more than one requirement, there is no single Requirement ID linked with the test. You can use the method GetCoverList from the Test Object to get a list of all requirements covered by the test
TAG : excel-vba
Date : November 17 2020, 11:01 PM , By : Henrique G Werlang
Excel VBA: How to know the Zoom of another worksheet?
Excel VBA: How to know the Zoom of another worksheet?
fixed the issue. Will look into that further What you're trying to achieve is not possible. You have to activate the sheet before you can change the zoom level, since it's a property of the window and not the sheet. From the MSDN documentation:
TAG : excel-vba
Date : November 10 2020, 11:01 PM , By : Vitaliy Priydun
VBA Cells as Keys in Dictionary
VBA Cells as Keys in Dictionary
I hope this helps you . Oh, I just figured out that I get the assumed behavior when reffering to cell values instead:This will allow duplicated values:
TAG : excel-vba
Date : November 07 2020, 11:01 PM , By : Alexandre Jaloto
Excel 2016 VBA - Problems upgrading from Excel 2013
Excel 2016 VBA - Problems upgrading from Excel 2013
hope this fix your issue As mentioned in the comments above, the solution to this problem was in eliminating missing references between different version numbers. In the Visual Basic interface, go to Tools->References. Check for missing references in
TAG : excel-vba
Date : November 04 2020, 04:05 PM , By : Seonwoon Kim
Ms Excel VBA - Using Shell command to open files
Ms Excel VBA - Using Shell command to open files
Any of those help I am developing a workbook in Excel-VBA and i want to execute a script using HEC DSS. That means, using excel-vba, i need to open "HEC DSS" first and then i'll instruct the application to open the script. , File paths with spaces sh
TAG : excel-vba
Date : October 29 2020, 12:01 AM , By : Durvesh Pilankar
Adding subroutine to hyperlink not working
Adding subroutine to hyperlink not working
To fix the issue you can do Use the workbook module, using this code will check the hyperlink text and then call the macro according to the hyperlink selection.
TAG : excel-vba
Date : October 20 2020, 03:08 PM , By : Hakka
Range formula last row
Range formula last row
Does that help I am trying to grab the last cell for my average, so I have it pulling a count from column A since column A does not have blanks, and determines the stopping point for my other columns. This works for my range functions, but I keep get
TAG : excel-vba
Date : October 18 2020, 03:08 PM , By : fellowhacker
Why is this VBA giving me a 1004 error
Why is this VBA giving me a 1004 error
To fix this issue I have tried a few different renditions here are some I THINK should work: , It seems to be the "!" before "$O2".
TAG : excel-vba
Date : October 17 2020, 03:08 PM , By : Siddhartha Kota
shadow
Privacy Policy - Terms - Contact Us © soohba.com