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

  1. Solved: Highlight cell from link
  2. Solved: Move rows to new sheet based on condition
  3. Solved: Emailing CC. recipients
  4. Solved: Sort Data and color code
  5. Solved: Inserting Rows after a count
  6. Solved: lookup the 4th characters in a cell
  7. Solved: Sinple question regarding calculating a due date...
  8. Identify the numbers that make up the average
  9. Generating an incremented workbook file & save as variable
  10. Solved: Digital clock within worksheet needed
  11. Solved: delete open workbook
  12. Regex in Excel 2007
  13. export worksheet problem
  14. Solved: VBA code for "or" + "and" functions
  15. Solved: Dynamically hide unused rows
  16. Solved: Open vba file
  17. Solved: Append matched row data from source wsheet back to corresponding row
  18. Enter, Tab and Up/Down Arrows Stop Working
  19. Does visual basic express work with excel?
  20. Downloading data from webpage into Excel
  21. copy values that aren't zero
  22. Solved: Filter & Transfer
  23. Solved: Delete Sheet list
  24. Solved: Get FileNames From Folder Not Using PathName
  25. Solved: Best way to go about?
  26. Solved: Copy a range from the fourth sheet on
  27. Transpose Question
  28. Solved: Minimum Positive value finder using VBA
  29. How can I make CopyPicture show the selected cell
  30. Solved: add leading zeros with a specified length of characters
  31. Solved: Finding the hour prior to original hour
  32. Summary sheet update keeping set columns in place
  33. Solved: search value and insert row under value
  34. From Excel Find Replace in Word 2
  35. Temporarily widen column
  36. help with print, clear and save maros
  37. Solved: Problem with formats
  38. Solved: Add to existing IF formula
  39. Change Drive Letter of Removable Storage
  40. Solved: Charting with labels
  41. Solved: Stumped - formulas required
  42. Copy adjacent cells and paste in non adjacent columns
  43. Solved: Function with multiple exit points
  44. Solved: Major issue blank cells
  45. Solved: VBA for Cell Link to network folder document.
  46. Solved: Excel Macro Not Setting a Cell's Value
  47. Multi Users in Excel
  48. Solved: Loop Until Blank or situation
  49. conditional formatting help
  50. Sorting a range of cells
  51. Delete Empty Sheets
  52. Solved: add headers to print then set page setup settings back.
  53. Replace Combobox with Listbox ...
  54. Solved: Copying between sheets
  55. Solved: checkBox-- Handle Value
  56. Solved: Exclude rows
  57. Solved: Copy specific cell based on date condition paste to specific cell
  58. Is it possible to loop a macro constantly?
  59. copy rows from worksheet 1 to worksheet 2
  60. Solved: Delete any spaces in cell
  61. Macro to copy, then paste to visible cells
  62. Solved: Copying data onto next empty row, under certain criteria
  63. Determining how a ComboBox was changed ...
  64. Using VB 08 to combine excel files
  65. Solved: SOLVED -- Update cells same sheet based on data changes
  66. Solved: Highlight ROW based on cell value
  67. Selecting a group of cells using the Range.offset syntax
  68. Solved: Printing a *.gif file from a command button depending a cell value
  69. Solved: Userforms created with macro
  70. Solved: Automation error
  71. Solved: Countif formula to be used on a dynamic range to be used on a data table
  72. Sum dynamic number of worksheets into one
  73. Solved: Cut entire rows to sheet on condition
  74. Solved: VBA Date Formatting with links
  75. Enter image based on cell value
  76. Solved: How to find the most common numbers?
  77. Solved: FSO Function to get Datelastmodified, DateLastAccessed
  78. Get sub group data based on main group
  79. Solved: MsgBox code to check for Existence of and Opened Files
  80. Solved: Autocomplete cells
  81. Solved: need help to create a "database" in excell
  82. Number of sorts allowed in XL2007
  83. Help Needed, E-mailing reports
  84. Solved: IsFileOpen and WorkbookIsOpen giving differing results
  85. Pivot Table data source
  86. Solved: Number Format from access field into excel
  87. Loop through chart and Highlight chart labels based on value
  88. Find number of lines ?
  89. Change to Month Sheet name
  90. Solved: User Defined Function Question
  91. Solved: URL -No Highlight Search Results.
  92. data validation from an add-in
  93. Problem adding References to Excel VBA App
  94. Autofilter Help
  95. Solved: Problem counting decimal places
  96. percentages and comparing two values whats the best way?
  97. Sequential Cell Numbering
  98. Database Question
  99. Solved: Rank Function Question
  100. Delete all characters after a set number in a cell
  101. find the closest date
  102. Insert sheet
  103. Urgent help Needed <<removing Rows
  104. Solved: Refresh data upon open
  105. Solved: Single member array problem
  106. Combining Project Timesheet Help
  107. Solved: Unprotect Sheets while looping through files
  108. Solved: Unorganized Summing
  109. select A2 through the last used cell in a column
  110. Interrupting a macro
  111. Copy Filenames from Folder
  112. Copy number of rows to formula result
  113. DPercentile
  114. Advanced Filter and Unique Count Code
  115. Using VBA to LOOKUP
  116. Simple VBA-code question
  117. basic unique refs loop
  118. VBA Copy based on offset
  119. Solved: Conditional Formatting Based on Percentage
  120. vlookup help
  121. How do I copy and paste cells that contain "@ml.com"
  122. Solved: Get absolute address for hyperlinks
  123. If statement not working
  124. Convert row into multiple rows of data (ARRAYS)
  125. Solved: Code to Move to next sheet
  126. Solved: Deleteing indertiminate spaces
  127. how to hide all menus from excel woorkbook?
  128. Solved: Excel Freezing every 30 seconds
  129. Solved: Show custom error message if file already opened by someone else
  130. Color Code row based on cell content
  131. Solved: Referencing a named range for a UserForm?
  132. Solved: Finding Last column in Row
  133. Select Case & Data Validation Issues
  134. Transferring data from two dimensional VBA array to Excel range -
  135. A different Change event
  136. Solved: Autofill Cells
  137. Solved: Inserting &amp; Naming New Columns in Multiple Worksheets
  138. got error 1004 when executing this code
  139. Runtime Error - Email Code
  140. Selecting sheets in add-in
  141. FInd Problems
  142. Solved: Deleting Empty Rows
  143. Solved: Cut and Paste macro
  144. SaveAs script
  145. Solved: INDIRECT OR INDEX OR WHAT? I'M LOST
  146. Solved: Strange Excel Error
  147. Solved: Set FollowHyperlink default Web browser
  148. VBA Excel and IE login info "Not Sharing"
  149. bind ListObject to Recordset?
  150. Solved: Pivot Table Update Data Source
  151. Solved: Run code on cell selection
  152. Solved: WorkSheet range Activate issue
  153. Excel form - listbox
  154. WinHttpRequest with HTTPS
  155. Solved: How do I create a range based on a column name?
  156. Click OK on a dialogue popup box
  157. Solved: matching that finds the greatest/least amount
  158. Solved: Test if an item exists within a collection data type
  159. Solved: Links to other data sources.
  160. Flash the TaskBar
  161. Code for detecting when a Msg box opens
  162. Solved: Convert row into multiple rows of data (ARRAYS)
  163. Solved: Code for printing.
  164. using (iserror) in if statement
  165. Solved: Repeat Column Insertation (It's simple!)
  166. trailing zeroes
  167. Sum for sub total and grand total
  168. Solved: Excel in Parallels Word not... Help
  169. create report for list of numbers
  170. Solved: Stop excel from calculating
  171. For Each-Next code tidying up
  172. Solved: If a condition is True how to add a number
  173. Solved: Blank cells
  174. Clearing my autofilter
  175. For Input as #1 Question
  176. Solved: AutoFilter macro issues
  177. Polygon's
  178. Solved: backgroundquery:=false seems to fail
  179. Adjusting macro from L.Notes to Outlook
  180. Copy Excel Range Into Outlook Email As Bitmap?
  181. Referencing Other Open Workbooks.
  182. Duplicate names for same range
  183. VBA : Populate list
  184. Solved: VBA for &quot;IF&quot; function
  185. Solved: Handling large ranges
  186. Solved: Replicating changes to one WS to others
  187. Excel Map gets destroyed when opened
  188. Solved: Transpose selected cells and place result on other sheet
  189. Confused about RefersTo
  190. Solved: IF CASE
  191. List population dependent on another cell
  192. hlookup and vlookup
  193. Workbook_Open Does Not Work
  194. Solved: Create History
  195. Need Help W/Sort
  196. Solved: Help using For loop in a IF then statement
  197. referencing of cells shows formula not values
  198. Solved: SOme one help find out what is happening
  199. VLOOKUP MACRO NOT WORKING PROPERLY
  200. Option Buttons
  201. "yyyymmdd_hhmm" change to Date, Time format
  202. need a code.....
  203. Solved: Display items of a collection in a message box?
  204. Solved: Inrease a number in a column basd on condition
  205. Macros in personal.xls execution based on different file names
  206. X-Y scatter graph refering a series of data log
  207. How to retrieve DataSource of chart
  208. macro to delete files - three days later
  209. Complex workbook_open solution needed
  210. Solved: Row to hide on drop down selection
  211. chasing ranges that move
  212. Ignore Hidden Sheets in vlookup macro
  213. Solved: Worksheets name
  214. Transfer items from list to textbox
  215. Solved: Create a rolling reference number
  216. Solved: macro for every cell on the sheet
  217. Solved: Counting number of pages in word
  218. Solved: file name extensions
  219. Solved: Email through Outlook contacts
  220. help with: suming only colour filled cells in a column
  221. Solved: Big Automation Question with Pivot Tables and Graphs
  222. Solved: VBA strangeness, need help please
  223. Solved: Listbox with data from other sheet problem
  224. VBA help - Vlookup
  225. Solved: Button to insert row in multiple worksheets and update
  226. Solved: ComboBox won't respond to repeat of previous selection
  227. Solved: Cmd Button Caption
  228. Solved: data validation question
  229. Solved: Find String and Merge Cells
  230. Solved: Disable Cmd Button
  231. Solved: Performing a task in vba if time is between 2 times?
  232. Solved: Limit Entries
  233. Open and refresh
  234. Autofilling a formulae to lastrow
  235. Sub reference as Cell
  236. Solved: XLD - Chart Help
  237. Saving a screen capture ~ PrintScreen (Excel '97)
  238. Help W/Small Code . .
  239. Help with Function
  240. Check Box Click()
  241. Copy Workbook, Saveas NewFile, Edit NewFile
  242. Help W/UserForm
  243. Funtions: For non-english Excel users
  244. Solved: Make NewWebQuery with URL-variable.
  245. exporting excel charts to Word
  246. Solved: extract a column to 5 column
  247. Loading Reference aborts Sub
  248. Solved: listbox little bug
  249. VBA Splitting the text 1-8 to (1,2,3,4,5,6,7,8)
  250. AutoCAD referencefiles?