read

I've been using a spreadsheet I created 5 years ago, which has grown and evolved the entire time. I use long and complicated formulas, many of which make heavy use of arrays, using INDEX and MATCH. I had to look at one of my formulas today, and noticed that NONE of my formulas are as they were...

Hi I can make an excel file as a read only, save as-->tool--> check read only (no password just read only). Now I open the file and it is read only. How can I undo that? I mean I remove read only thing. Thank you very much

I have the following: Sub Automatic_Highlights(Rng As Range) If Rng.Range("O:T") = True Then GoTo Skip ' In my head this should read "If Rng falls within Range("O:T"), Then GoTo Skip"; Or that's how I want it to read at least. Rng.Interior.ColorIndex = 7 Intersect(Rng.EntireRow...

Hello! Is there a formula that will read the numbers from a column that contains numbers but stored as text? Thanks!

Let's say in cell A1 the value is "$E$1" Let's say I want to calculate the max value of E1:E10 Normally, I'd use: =MAX($E$1:E10) But for my purposes, I want the formula to read the text entered in A1 to set the start of the range: =Max((read value from A1):E10) I am trying to figure out how...

Hello I use this code to open workbook 2 from workbook1 Dim LastRow As Range Dim ws As Worksheet Set ws = Sheets("Worksheet") Workbooks.Open Filename:="R:\General\COVER SHEET_Protective\Protective Packaging Order Log.xlsm", Password:="PP"...

Hi. I have a data set that is annual values for various colors. For each of these colors, in any year the value will be 0 or greater. For each year, I would like to have a cell list all the colors that are non-zero for that year. For instance, for the table below (apologies for formatting)...

Hi all, i want to read a link to a mp4 file from this website: http://www.4players.de/4players.php/...aming_GPU.html Here is a screenshot where you can see the mp4 File. I use the Firefox inspector, and he show the link? How can i get this link? https://share-your-photo.com/e62e9e98cf I am...

Is there any vba book I should read for beginners

Hi, i need to get read one Excel sheet and update records in another workbook excel sheet by vba Please guide me . Thanks for your support This is reading file <tbody> Number Code Value 1 03-01-00-01 15 2 03-02-00-02 10 3 03-03-00-06 2 4 50-01-00-15 11 5 50-01-00-16 9 6...

Hello I ve used the following and getting the figure as _(5036882.00) Textbox4.text = Format(Ws.Cells(3, 10).value, "_(*#,##0.00_);_(*#,##0.00);_(* ""-""??_);_(@_)") How the same can be read as 50,36,882 or 50,36,882.00 if i remove the underscore from above syntax still reads as 5,036,882...

Hey, I have an excel sheet that multiple users will need to access at various times. I've recently run into the issue where a few of them have tried to open it at the same time as another, enter data, and try to save it while it is in read only. I tried a few macros to keep them from opening...

Hi , can anyone help me with below query. i have a collection of arrays. and i need to read the values. eg: Dim resColl As New Collection resColl.Add Array(key, Key3("UserName"), Key3("Password")) in above add method i added arrays with 3 elements. and after adding i need to read the...

Hi, I have the following code; Private Sub Workbook_BeforeClose(Cancel As Boolean)Dim ws As Worksheet Sheets("START").Visible = xlSheetVisible Application.EnableEvents = False For Each ws In ThisWorkbook.Worksheets If ws.Name <> "START" Then ws.Visible = xlVeryHidden End If Next ws...

I'm automating the import of a particularly large CSV file. This file is generated by the user, and I want to validate that it is in the correct format (column order & names) before continuing the macro. Ideally, I'd like to read the header row from the file before committing to opening the...

Hi Im trying to get a code that can take data from multiple cells from sheet1 and place them in the same cell on sheet2 but the tricky part is keeping the same colors of the text from sheet1. For example sheet one A1-Roses A2-Are Read should read on sheet2 A1-RosesAre Red

Is there a way to read UniqueValues.xlDupeUnique enumeration instead of only declaring/assigning it? Thanks y'all.

I am a set of data where I needed to unstack the data so every row of data represents a single person. However, I need to copy a variable so that spans each row. For example, in cell E2, I have '12' and then in E3 and E4, they are blank but I need them to read 12. Same for the next 2000ish...

I have a workbook that has a tab for each month of the year. So more or less each tab is just a calendar. So for each day of the week in each calendar there are 6 cells for each day a user can enter data in. For example Thursday the 22nd of November is in cells E25-E30. These are cells where...

Hi All, I have had a read through other posts can cant find exactly what i am after, i can find script for each individual part but when i try and put them together i can can only get one half to work. I would like to monitor target cells in another sheet and record the value that was in the...