Hi Folks!
I was trying to write some Python script to calculate resistor values for electronics projects, and wanted to generate lists of the preferred resistor values in each standard commercially available ranges of values (E6, E12, E24 etc.) by formula rather than using large unwieldy lists or directories..
From what I've been able to find by reading & Googling, the "E series" of preferred values are...
Search Result
Collapse
2 results in 0.0041 seconds.
Keywords
Members
Tags
-
vbanewb14 started a topic How can I edit this code to use a variable instead of specific cell references?in Visual BasicHow can I edit this code to use a variable instead of specific cell references?
Does anyone know how I can change this line of my code to reference a variable in place of "R172"? I can't use "Range" because I want to use the values in 2 cells far apart from each other.
.Values = "=(ARLSummary!R 4C7,ARLSummary! R172C7)"
Code:LChart.Chart.SeriesCollection.Add Source:=Trange With LChart.Chart.SeriesCollection(2)