PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 [87] 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174

  1. Solved: VBA Assigning Variable / Runtime Error 1004
  2. Solved: Supressing '#N/A' in WorksheetFunction.VLookup
  3. tab colour
  4. Combinations
  5. ANNIVERSARY DATE
  6. Solved: Sales forecast
  7. Check box control on a worksheet
  8. Solved: cell.adress question
  9. Solved: number format 0.00 €/m²
  10. Macro to do logic based on other column
  11. Solved: .FormulaR1C1 = "=" & Formula_A
  12. Solved: copy paste doesn't work
  13. Solved: TextBox: Entering Date in specific format
  14. Excel VBA. Calculating worktime with different overtimes
  15. [SOLVED:] Optionbutton deselection erases range value
  16. Solved: Copy/Paste All Cells on a Non-active worksheet
  17. Need a reference on where I can hire a local vba Excel expert to work on a project
  18. how to remove some range of cell only,
  19. [SOLVED:] Further variation of Index/Match
  20. Toolbare with option
  21. Solved: Concatenate If in an Array
  22. Custome objects and Collections Classes. Help Please!!!
  23. Selecting a range of sheets using crit in my Criteria
  24. Solved: Printing Problem
  25. Macro help - "Force Use Macros" plus "Auto Close"
  26. Strange formula - now sure how it works
  27. Automatic Cut/Paste to new sheet at every month end
  28. Solved: Trouble Storing Worksheet in a Variable
  29. [SOLVED:] Rounding in units of 0.5
  30. Error handling: #REF!
  31. do not display hide worksheets in data validation list
  32. Solved: Array Formula not recognizing Imported Data as a Number
  33. Solved: Validation data - excluded from list
  34. Solved: VBA - Value Copy Multiple Criteria
  35. Noob with a (probably) simple one
  36. Find problem
  37. [SOLVED:] Question on Hpyerlink
  38. cells colour
  39. Consolidating multiple sheets onto one "parent" report sheet.
  40. Adding a chart
  41. Excel Chart Object Name
  42. Solved: display msgbox once
  43. Edit objects
  44. Delete rows when the code gets deleted.
  45. checking string in IF Loop
  46. VBA for combo box
  47. Is it possible to write vba code to create a conditional format on cells?
  48. "FindNext" function
  49. Solved: Using Excel To Send Emails Through Lotus Notes
  50. Retrieving Data from another Worksheet
  51. Solved: Login Prompt
  52. Solved: Positioning UserForms
  53. Solved: TRIM in VBA
  54. [SOLVED:] Is it Vlookup or Sum Product ?
  55. Excel + Access Help
  56. Solved: need dynamic range
  57. option button macro
  58. Solved: Need to loop thru a folder of workbooks and extract customer addresses
  59. comparing the 2 excel
  60. Solved: Enter the next consecutive number
  61. Listbox active workbooks and copy data
  62. using Excel function TRIM rather than VBA function TRIM
  63. Clear contents in the last populated cell
  64. email different sheets to different people - code needs changing
  65. Is it possible to transfer data from ms access to excel using vba code?
  66. Solved: Conditional Formatting only when value is present
  67. Solved: Import a Silhouette & select X & Y coordinates then do a vlookup Based on the value
  68. Solved: Loop through controls and add data from cells
  69. Searching from a list in Excel, extract Phone#'s from contact's in outlook 2003
  70. Solved: Make sure numbers are increasing
  71. Navigating Through a Recordset (Adding a Record Counter)
  72. Create 1 Public Sub for 5 textboxes
  73. Solved: POP UP Message when a criteria is met
  74. Menu tree
  75. Formatting a column into "text"
  76. data model in excel
  77. Solved: Excel, append & retrieve numbers in a txt file with next number in increments one
  78. Using iMacros in a loop with input from Excel
  79. Solved: how do i get the the name of the user who opened the file?
  80. Using vba to open website
  81. Solved: Locate values from List
  82. [SLEEPER:] Extract rows to new worksheet and save as new workbook
  83. Excel Problem
  84. Solved: Selection Rows CountA?
  85. Solved: Code not updating all worksheets
  86. SSN Format
  87. Update code in 220 objects
  88. SUM IF in vba and result in message box
  89. Solved: Problem with copy/paste "Formats"
  90. Using Yes No Message Box
  91. Excel 64bit issue with Winsock UDP connection
  92. Automatic Macro execution
  93. Insert Hyperlink from External Source to a Protected Sheet
  94. VBA Chart fill area
  95. Excel 2003 VBA coding and "pop up button" help
  96. Excel 2003 VBA coding tweak
  97. Read external data from dynamic text range, then calculate stats
  98. Solved: Two listboxes on same userform problem
  99. File (path to a folder) not found
  100. creating a data base using Excel & VBA
  101. Print workbook - disable
  102. How do I close an instance of Quickbooks in VBA?
  103. Sum Values in defined target
  104. Solved: need a magic formula to ..
  105. Write data to sheet 2 if sheet 1 is full
  106. "Window" menu item
  107. VBA Help needed total newbie
  108. DOM: Searching only the tags embedded within one particular div tag
  109. Macro help required if possible
  110. Excel keeps switching between 'ready' and 'chart updating'
  111. Solved: Clear Red Interior if Text is Red
  112. excel addin problem
  113. count the no. of A
  114. VBA Copy & Paste
  115. Excel 2007/2010 - Can I have workbook specific disabling of row inserting?
  116. System Error: &H8001010D (-2147417843) An outgoing call cannot be executed...
  117. VBA code below
  118. Filter Sheet With text on cell
  119. VBA array difficulty
  120. Is it possible to use vba to automate a count on recurring data?
  121. Solved: Input Box Validation please help
  122. Solved: Find maximum value in a column
  123. Excel stopwatch needed
  124. max value of another textbox
  125. Open web Page and clink on a link within the page
  126. Set Cell Value As Variable?
  127. How to turn any URL input into file name
  128. pervent only one sheet from deletion
  129. Sumif
  130. Creating charts using VBA: problem with intervals
  131. Report from excel database ??
  132. Ado DB connection in Excel
  133. Solved: Create new folder with name and date
  134. Solved: VBComponents - how to retrieve "Sub" or "Function" exactly
  135. Need help with default save script from 2010 to 2003
  136. Return control after application.run
  137. [SOLVED:] Split cell contents into multiple rows
  138. Solved: Selecting a Rows with Data
  139. using conditional formatting
  140. Solved: Mortgage loan spreadsheet problem
  141. Finding special charecters in excel
  142. formula for logical condition
  143. Solved: Code prevents formulas working!
  144. Solved: Merge Workbooks
  145. Sending Excel Cell Data via E-Mail
  146. Solved: Why does code need On Error Resume Next?
  147. SaveAs Command to Overwrites a Excel File
  148. Detecting a cell change
  149. Data Input Form Workbook
  150. How to select option in pop-up list????
  151. excel VBA and post for ASP.NET
  152. Solved: display multiple labels as $0.00
  153. Solved: use input box chara to create new woorksheet name
  154. [SLEEPER:] Run-time error '13' on comparing arrays help needed
  155. Is it possible to upgrade Excel and perform File Remediation using vba?
  156. clear contents formula
  157. Solved: Ignore Countif If Cell Contains a Value
  158. Solved: Disable all saving
  159. Is that possible to excute code by using Keboards "CTRl+Eneter"
  160. Highlight The Selected.
  161. VBA code-Signature code failure
  162. Cut and paste the challenge
  163. Error using Find function
  164. Solved: Insert row above next empty cell within a column
  165. Solved: Question About copy Selection
  166. Basic question about Application.enableevents
  167. highlight the cell with "peter"
  168. Solved: Excel - Change font color if invoice number is out of order.
  169. Solved: disable protected sheet message
  170. Problem switching between Excel and Word
  171. Sleeper: Input Mask
  172. UDF to calculate average according to condition, ignoring blanks
  173. Solved: Specific cell selection
  174. Compile Error
  175. Update only the latest data from Excel to Access table
  176. Extract data from PDF
  177. VBA Select Case
  178. Help with clear contents
  179. Is there a formula or statement that works out percentage rates in Excel?
  180. Solved: Search for text in IE
  181. Last row of the worksheet
  182. [SOLVED:] How to print from sheet active to the another sheet
  183. Loop the code
  184. Worksheet Delete
  185. Transpose single column array
  186. Solved: Stop CommandButton moving or rename button
  187. Solved:
  188. Request for review
  189. Solved: Select Row problem
  190. Help defining and setting variables
  191. Permutations
  192. Solved: Decrease qty thru msgbox
  193. Loop Help
  194. VBA to export 2 worksheets at a time
  195. For loop trouble
  196. Printing Copies with VBA
  197. Solved: Only copy selected sheets
  198. VBA code to run on specified time
  199. Solved: Nested IFs
  200. Solved: Directory Path
  201. VBA match, copy , paste and append
  202. Solved: need to contain clearing of row within a range
  203. [SOLVED:] Spinbutton and date textbox
  204. Mortgage spreadsheet concept problem
  205. Action when result of formula changed
  206. Solved: Help with loop please
  207. Solved: Columns to Rows keeping data integrity
  208. Solved: userform label format
  209. Solved: Macro to go to first worksheet in any workbook
  210. Solved: Delete after first space
  211. Copy Data to the Serial Number Row
  212. [SOLVED:] Simple Formatting
  213. Solved: spinbutton on date textbox
  214. Inserting an image based on the option choosen
  215. Disabling multiple textboxes
  216. Label Calculation
  217. Solved: .text to .value
  218. [SOLVED:] Finding text on ie that's next to what you search
  219. Timed VBA Mail code
  220. Solved: Set the Data / Group and Outline / settings..
  221. Cannot get the protection code to work with the rest
  222. Excel workbook "access denied"
  223. Delete the repeated code
  224. Office 2003 Combobox_Enter
  225. Solved: Disable Form Control Button/Code
  226. Solved: The Art of Conditional Formatting!
  227. Solved: Text to columns (With only the first bit of text)
  228. Solved: Create and Edit a Scheduled Task from Excel
  229. Solved: Check the clipboard for Data before paste?
  230. Comparing values from Different worksheets
  231. Need to preventt xlsm file from being converted to xls
  232. Dynamic chart-Modify series formula from vba
  233. Multi sheet macros.
  234. Solved: calculate difference between 2 excel files
  235. Solved: VLOOKUP multiple criteria
  236. Business Days
  237. Modify code to also remove cell borders
  238. Disable Fn Alt and Ctrl Keys
  239. vba password recovery
  240. Copy and Paste between Instances of Excel
  241. Change Column Content
  242. [SOLVED:] How to populate array with collection?
  243. Excel Macro to delete rows if cell matches List of Values
  244. [SOLVED:] find all combinations (no repeats)
  245. Excel 2007 VBA SOAP Web Services Integration
  246. Excel Edit Mode Bug?
  247. Solved: How To Sum Worksheets
  248. bar chart with stacked option
  249. Solved: how can i get labelname in graphic
  250. Excel/vlookup if statement confusion